Up till 3 every night... Got a little zip left in me yet...

Thanks for understanding.

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

----- Original Message -----
From: "Brian Dunstan" <bdunstan@...>
To: <IBObjects@egroups.com>
Sent: Friday, December 01, 2000 1:07 AM
Subject: RE: [IBO] TIB_LookupCombo case insensitive inc search


> Jason,
>
> > -----Original Message-----
> > From: Jason Wharton [mailto:jwharton@...]
> > Sent: Friday, 1 December 2000 3:55 PM
> > To: IBObjects@egroups.com
> > Subject: Re: [IBO] TIB_LookupCombo case insensitive inc search
> >
> >
> > Brian,
> >
> > After looking into this I now recall some things that I forgot.
> >
> > InterBase doesn't allow the ORDER BY clause to look like this:
> >
> > /*---
> >
> > PREPARE STATEMENT
> >
> > TR_HANDLE = 13589512
> >
> > STMT_HANDLE = 13589348
> >
> > SELECT DEPT_NO
> >
> > , DEPARTMENT
> >
> > FROM DEPARTMENT
> >
> > WHERE DEPT_NO > ? /* PRM_0 */
> >
> > ORDER BY UPPER( DEPARTMENT ) ASC
> >
> > FIELDS = [ Version 1 SQLd 11 SQLn 2
> >
> > EMPLOYEE.EMP_NO = <NIL>
> >
> > EMPLOYEE.FIRST_NAME = <NIL> ]
> >
> > ERRCODE = 335544569
> >
> > ----*/
> >
> > /*---
> >
> > INTERPRETE BUFFER =
> >
> > ERRCODE = 17
> >
> > ----*/
> >
> > /*---
> >
> > INTERPRETE BUFFER = Dynamic SQL Error
> >
> > ERRCODE = 21
> >
> > ----*/
> >
> > /*---
> >
> > INTERPRETE BUFFER = SQL error code = -104
> >
> > ERRCODE = 30
> >
> > ----*/
> >
> > /*---
> >
> > INTERPRETE BUFFER = Token unknown - line 5, char 8
> >
> > ERRCODE = 5
> >
> > ----*/
> >
> > /*---
> >
> > INTERPRETE BUFFER = UPPER
> >
> > ERRCODE = -1
> >
> > ----*/
>
>
> Understood.
>
>
> > So, the conclusion to this is you need to have a true mirror column
> > maintained by triggers or you need to declare a COMPUTED
> > column at the table
> > level.
>
> OK.
>
>
> > I don't think it is possible to use an aliased column from
> > the select list
> > in the ORDER BY clause either. It's either columns in the
> > table or the raw
> > number indicating the numerical position of the column in the
> > select list.
>
> That is correct.
>
> > I happen to think that enhancing the SQL capabilities of
> > InterBase here
> > should be a good morsel for the folks at Borland and/or the
> > FireBird folks.
>
> Ah yes, but by then my conversion will be long done (I hope).
>
>
> > Sorry to string you along here!
>
> Hey, thanks for staying up to answer. By my calcs it is past 1 AM there. I
> am impressed - time for bed :-)
>
>
> > Regards,
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
>
> Regards,
>
> Brian
>
>
> >
> > -------------------------- eGroups Sponsor
> > -------------------------~-~>
> > eLerts
> > It's Easy. It's Fun. Best of All, it's Free!
> > http://click.egroups.com/1/9699/1/_/685810/_/975657713/
> > --------------------------------------------------------------
> > -------_->
> >
> >
> >
>
>
>
>