Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have some preparation work to do for representing data based on user inputs.
I saw the DynamicUpdateCommand used in some examples (e.g. RoutePlanner). I started to experiment but run into multiple limits, e.g. I can only delete records with the equation operator "=" but not with "<>" or "!=" or simply delete all (it insists on a where clause)?
I was not able to find documentation about the supported command syntax.
Any hints?
Delete all:
DELETE FROM TestTable WHERE -1
Update all:
UPDATE TestTable SET TestField= 123 WHERE UpdateTag=1;
You have to implement a "UpdateTag"-field in the Table.