At 11:29 AM 28/09/2004 +0000, you wrote:

>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'

Well, you could include NAME in the KeyLinks. I assume the idea is perform
the update only if someone else didn't already commit a change to the name.

Or is there some other reason behind this?

Helen