Hi!
I'm using IBO 4.2.Fm and I have a problem when I try to use the
lockSQL property with a TIBOQuery.
If I set the pessimistlock=true without write the locksql, everything
is ok, but, if I specify the locksql command I have the message that
the record is in use! But I haven't any user editing the same
record...

I have one field named "Lock_Flag", that tell me if the record is
locked or not, but I can lock the record with the following locksql
command:

update table
set lock_flag='S'
where ID_Table=old.ID_table

If anyone could help me...

Best regards,

Rui