[Solved] SQL How to update current row

[gkick]

Hello,

Have a timestamp for record created, one for record changed, a field created by default user name and need another one for record changed by.
The normal sql syntax UPDATE "tblxxx" SET "yyyy" = "zzz" needs a WHERE clause so that only the selected record is updated. There does not seem to be a record number property and according to the HSQL man the rownum() can not be used for = or > condition.

Anyone done something similar ?


Thks

[Villeroy]

Your table should have a primary key to identify a distinct record.

[gkick]

Ahh, thanks that's it, store the pk to a variable and use it in the where clause, thanks !!!