DynamicUpdateCommand limits on syntax?

Mon, 22 Feb 2010 16:40:08 GMT

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?

DynamicUpdateCommand limits on syntax?

Fri, 20 Jan 2012 16:44:34 GMT

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.

topic DynamicUpdateCommand limits on syntax? in QlikView

DynamicUpdateCommand limits on syntax?

DynamicUpdateCommand limits on syntax?