Syntax for DynamicUpdateCommand

Fri, 24 Jul 2009 19:11:46 GMT

I try to modifiy data dynamically.

To insert one record I use the statement:
Res = ActQvDoc.DynamicUpdateCommand ("INSERT INTO user (usr_name, fullname, GROUP) VALUES ('Hallo1', 'AutoUser', 'ADMIN')")

To delete one record I use the statement:
Res = ActQvDoc.DynamicUpdateCommand ("DELETE FROM user WHERE (fullname = 'AutoUser')")

To delete more than one record or to append records from an other table I do not find the correct syntax. Is there anywhere a description for the syntax to use?

The statements like following do not work:
Res = ActQvDoc.DynamicUpdateCommand ("DELETE FROM user WHERE (fullname like 'AutoUser%')")
Res = ActQvDoc.DynamicUpdateCommand ("DELETE FROM user WHERE (fullname = 'AutoUser*')")

Thanks
Valerio

topic Syntax for DynamicUpdateCommand in QlikView

Syntax for DynamicUpdateCommand