Hello,
I’m trying to put down a DynamicWhere … as an attachment what I have set… Did I forget a parameter because the server does not execute the Were.
Greetings Mark
Hi,
looks like you have mixed Dynamic Select and Dynamic Where features.
DynamicSelect allows to receive selected fields of table instead of all.
DynamicWhere allows to apply filtering on DB server.
we have Dynamic Select sample (Delphi) and Dynamic Where sample (Delphi).
I can suggest to review them.
–
You can set breakpoint at server-side at uDAEBaseDataset.pas at 440 line:
NativeDatabaseAccess.Active := True; and evaluate GetSQL. it should contain generated SQL.
I am familiar with the examples; I actually copied my dynamicWhere from there… I am not getting any errors on either the server or the client… nothing is happening. Attached is part of the SQL string that I read using the GetSQL function in uDAEBaseDataset. Everything is as I entered it… the {Where} has not been replaced…
ncps.Id’#$D#$A’WHERE’#$D#$A’ {WHERE}‘#$D#$A’AND ncp.client_id = :client_id’#$D#$A’AND ncpa.type_id = :type_id’#$D#$A’{ORDERBY}’
Could it be because I am using my own SQL statement?
Hi,
{WHERE} should be replaced with something like (ncp.group_id = '...').
Can you attach simple testcase that reproduces this issue, pls?
You can drop it to support@ if you want keep it in privacy.
Ok here is the demo … what else I f
DemoApp.zip (165.0 KB)
ound out … if I use Message Bin and not Json then it works …
