Hi
I've got TIB_Query with SQL looks like this:

SELECT a, b, c
FROM my_table
WHERE a = :a
WITH LOCK

It works ok, I can see in IB_Monitor that statement is passed to FB as above. But when I add ORDER BY clause to SQL:

SELECT a, b, c
FROM my_table
WHERE a = :a
ORDER BY a
WITH LOCK

parser cuts off WITH LOCK clause :/
This statement in "real life" returns few records, so I need order by.
I know that IBO has built in features like PessimisticLock, LockSql etc, but that's not the point.

Regards, Tomek