Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

DynamicUpdateCommand limits on syntax?

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?

1 Reply
Not applicable

DynamicUpdateCommand limits on syntax?

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.

Community Browser