Subject RE: [IBO] Dynamically generated SQL with TIBOQuery
Author Brian Dunstan
Jason,

my apologies. I should have created a simple demo BEFORE I posted! I had a
silly coding error that I couldn't see for looking, and I have been looking
at it for hours.

Thanks anyhow :-)

Brian

> -----Original Message-----
> From: Jason Wharton [mailto:jwharton@...]
> Sent: Wednesday, 22 November 2000 10:20 AM
> To: IBObjects@egroups.com
> Subject: Re: [IBO] Dynamically generated SQL with TIBOQuery
>
>
> Please provide a simple demo.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Brian Dunstan" <bdunstan@...>
> To: <ibobjects@egroups.com>
> Sent: Tuesday, November 21, 2000 7:13 PM
> Subject: [IBO] Dynamically generated SQL with TIBOQuery
>
>
> > I have encountered a problem with one of the forms I have
> converted from
> BDE
> > -> IBO.
> >
> > The form allows the sort order of a grid to be changed at
> runtime. The
> > IBOQuery is closed, the last line of SQL (which has the
> ORDER by clause)
> is
> > deleted from IBOQuery.SQL and a new ORDER BY clause is
> added and the query
> > opened again.
> >
> > That worked fine with TQuery. But it does not work with TIBOQuery.
> >
> > When I look at what is happening with the monitor I find
> that the original
> > ORDER BY is not deleted from the statement before it is
> prepared, so an
> SQL
> > error results. In other words, the statement being sent to
> the server is
> not
> > the same as the statement in IBOQuery.SQL. Why?
> >
> > It appears that IBO is trying to do something smart with
> the ORDER BY but
> is
> > getting it wrong.
> >
> > Any assistance would be greatly appreciated,
> >
> > Thanks,
> >
> > Brian
> >
> >
> >
> >
>
>
> -------------------------- eGroups Sponsor
> -------------------------~-~>
> eLerts
> It's Easy. It's Fun. Best of All, it's Free!
> http://click.egroups.com/1/9699/3/_/685810/_/974859970/
> --------------------------------------------------------------
> -------_->
>
>
>