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.

This will be fixed in the next release IBO 4.9.13 Beta 23.

Thanks for reporting this.

Jason LeRoy Wharton
www.ibobjects.com