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*')")
