Subject | FOR UPDATE |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2001-08-01T23:25:01Z |
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
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