Hi,
I have mutiple records in a table with an Autonumber as the primary key.
How would I go about updating a number of those records using a smartobject/service method.
Eg:
TableID - Autonumber
Field1 - Number
Field2 - Text
Field3 - Date
Field4 - Number
Normal SQL Server syntax would be:
Update MyTable SET Field1 = 5, Field2 = 'Updated' WHERE Field4 = 67 AND Date >= '2009-01-01'
I tried similiar syntax with K2 and it created a new record and did not update the existing records.
I would imagine the delete syntax would have a similar problem???
