Hello,

How can I solve this problem:

sql = "update table1 set table1.field1 = table1.field1 +1 where .....

I don't want to use stored procedures...

Best regards

There's an example in the manual which does: "update table1 set table1.field1 = table1.field1 + (table1.field1 * 0.1) where..." so effectively the same structure. The example is in: Using the generated code, Field expressions and aggregates -> Expressions in entity updates.