LockSQL property

Applies to
TIB_Dataset

Declaration
Property LockSQL : TIB_StringList;

Description
This property works almost exactly like the EditSQL property except its purpose is to merely perform a dummy update to whatever record that you want locked.

For example:


UPDATE MYTABLE SET
MYCOL1 = MYCOL1
WHERE MYKEY = :OLD_MYKEY

This property will most likely be useful for specialized situations since IBO will automatically perform this when KeyLinks are supplied.

Notice how there is only a parameter used on the OLD_MYKEY column and the other simply uses the direct table value set to itself.