| Subject | update when changed |
|---|---|
| Author | bemmel2003 |
| Post date | 2004-09-28T11:29:12Z |
Hi,
My TIBO-query (dynamic sql) updates only changed fields like:
UPDATE relations SET name = 'Smith' WHERE ID=1000
but I want to change it so that the changed fields together with the
key-fields appear in the WHERE clause like:
UPDATE relations SET name = 'Smith' WHERE ID=1000 and name = 'OldName'
How can I do this the easy way ?
Leon
My TIBO-query (dynamic sql) updates only changed fields like:
UPDATE relations SET name = 'Smith' WHERE ID=1000
but I want to change it so that the changed fields together with the
key-fields appear in the WHERE clause like:
UPDATE relations SET name = 'Smith' WHERE ID=1000 and name = 'OldName'
How can I do this the easy way ?
Leon