I have a small problem with rewriting something sql
I usually code Mssql but I stand in the situation that I have a client who is going to use some software, but they have a pervasive database. and I will I have a record locked. but I must also return the fule record.
in Mssql, I would write:
UPDATE [TableName] WITH (ROWLOCK) SET [CellName] = [CellName] + 1 OUTPT INSERTED.*