Subject | RE: [IBO] Re: Strange error |
---|---|
Author | Jason Wharton |
Post date | 2005-10-20T00:56:01Z |
I may need to do some things inside IBO to accommodate this unique
situation.
Jason Wharton
situation.
Jason Wharton
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Helen Borrie
> Sent: Wednesday, October 19, 2005 5:23 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Re: Strange error
>
>
> At 05:38 PM 19/10/2005 +0000, you wrote:
> >--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> > > Wrong InterBase or Firebird message file?
> > >
> >
> >Nope, not a wrong message file. After an hour or so with the
> >debugger here is what I have found:
> >
> >Original contents of TIBOQuery SQL:
> >
> >SELECT LDS_NAME
> > FROM LD_STOP
> > WHERE LDS_TEMPLATE_FLAG = 'N' AND
> > LDS_LOCATION = :LDS_LOCATION AND
> > LDS_LOAD_NUMBER = :LDS_LOAD_NUMBER AND
> > LDS_LOAD_SFX = :LDS_LOAD_SFX AND
> > LDS_STOP_NUMBER = :LDS_STOP_NUMBER
> > PLAN (LD_STOP INDEX (LDS_STOP_KEY))
>
> Ah! don't put the plan in the SQL property, put it in the
> SQLPlan property
> (or in the Plan property, if you are using TIBOQuery).
>
>