I need your table specs to reproduce this.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <hans@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, August 01, 2001 4:25 PM
Subject: [IBO] FOR UPDATE


> 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
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>