Logged as a low priority bug.

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

----- Original Message -----
From: <hans@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, August 02, 2001 12:06 AM
Subject: Re: [IBO] FOR UPDATE


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