Subject FOR UPDATE
Author hans@hoogstraat.ca
Some playing with IB4

On IBOQUERY, IB_QUERY

SELECT * FROM EDF
FOR UPDATE
WHERE PROGRAMTYPE='T'
ORDER BY PROGRAMTYPE,CODE,SFROM DESC, STO DESC

SELECT * FROM EDF
WHERE PROGRAMTYPE='T'
FOR UPDATE
ORDER BY PROGRAMTYPE,CODE,SFROM DESC, STO DESC

all accepted fine, but ordering haywire, even
when OrderLinks used.

SELECT * FROM EDF
WHERE PROGRAMTYPE='T'
ORDER BY PROGRAMTYPE,CODE,SFROM DESC, STO DESC
FOR UPDATE

However when FOR UPDATE is the very last statement,
ordering works as expected, since it is the correct syntax.

Just wondering if an error could be produced when FOR UPDATE
is misplaced ?

Can be tested from IB_WISQL

Best Regards,
Hans