Table specs as asked for. It seems to make no difference
which table. Not having 'FOR UPDATE' clause placed as the
last statement, although incorrect, gets accepted, but
messes up any defined ordering sequence. No real
problem, but it maybe be hard to find were you goofed up :)

====
CREATE TABLE EDF (
ERECNO INTEGER NOT NULL
, CRECNO INTEGER
, QNUM INTEGER
, PROGRAMTYPE CHAR( 1 )
, CODE VARCHAR( 12 )
, SRECNO INTEGER
, STRECNO INTEGER
, EVENTTYPE CHAR( 1 )
, SFROM DATE
, STO DATE
, ESTYEAR INTEGER
, COST DECIMAL ( 9, 2 )
, VERIFIEDCOST CHAR( 1 )
, VERIFIEDBY VARCHAR( 8 )
, DUPDATED DATE
, TUPDATED TIME
, WUPDATED VARCHAR( 8 )
, COMMENT BLOB( 65535, 1 )
, PRIMARY KEY ( ERECNO )

====


Jason Wharton wrote:

>
> 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