Update field using same field as key with Simple.Data

Question

I want to achieve this:

UPDATE MyTable SET Field1=Field1 + 1 WHERE Field2 = 1 AND Field1 = 5000

Just to explain why is that im verifying that nobody else touched the record, Field1 is a sequence number.

How to achieve this, im thinking something like. MyDb.MySchema.Table.UpdateByField1AndField2(Field1: 5000, Field2: 1, Field1: 5001). Obviously this does not work.

and your question is? – DarkSquirrel42 Apr 08 '13 at 19:27 — DarkSquirrel42, Apr 08 '13 at 19:27
Updated the quested with "non-working-example" – Lars Stenberg Apr 08 '13 at 19:30 — Lars Stenberg, Apr 08 '13 at 19:30

score 1 · Accepted Answer · answered Apr 08 '13 at 19:38

1

what about ...

MyDb.MySchema.Table.UpdateAll(Field1: 5001, Condition: MyDb.MySchema.Table.Field1==5000 && MyDb.MySchema.Table.Field2==1)

?

answered Apr 08 '13 at 19:38

DarkSquirrel42

10,167
3
20
31

Update field using same field as key with Simple.Data

1 Answers1