Subject | "with lock" and TIB_Query parser |
---|---|
Author | tomjanczkadao |
Post date | 2011-03-30T12:07:36Z |
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
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