Thanks Jason - so simple in the end - I am very relieved to have my
sanity back.

I will look at the Help and Getting Started Guide notes as these
could perhaps be clearer - at least for newbies like me.

Thanks again.

Francis Moore

--- In IBObjects@egroups.com, "Jason Wharton" <jwharton@i...> wrote:
> Perhaps you are confusing the SQLWhere property with the
SQLWhereItems
> property?
>
> SQLWhere is merely the entire WHERE clause including the WHERE
token itself.
>
> SQLWhereItems is a property used to accumulate additions to be made
> automatically to the WHERE clause for you during the OnPrepareSQL
phase.
>
> Carefully review the notes with this distinction in mind and see if
this
> clears things up for you.
>
> Thanks,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Francis Moore" <moorefg@n...>
> To: <IBObjects@egroups.com>
> Sent: Tuesday, December 12, 2000 5:07 PM
> Subject: [IBO] SQLWhere
>
>
> > I am having consistent trouble with SQLWhere. It must be
something
> > in my IBO setup as this has consistently failed to work - followed
> > all of the Help and Tutorial and the new Getting Started Notes.
> >
> > Each time I am getting an error along the lines of:-
> >
> > 'ISC Error Message
> > Dynamic SQL Error
> > SQL Error Code = -104
> > Token Unknown Line 14 Char 5
> > =
> > '. Process Stopped. Use Step or Run etc.
> >
> > Code I am currently using though I have tried may variants per the
> > Help and Getting Started Guide is
> >
> > procedure TISAS_Library_Form1.IB_Query8PrepareSQL(Sender:
> > TIB_Statement);
> > begin
> > with ISAS_Library_Form1.IB_Query8.SQLWhere do
> > begin
> > Clear;
> > Add('POLICY=:Policy' ) ;
> > end;
> > end;
> >
> > The SQL Query is very simple
> >
> > SELECT SCHEME_REF
> > , PLAN_REF
> > , POLICY
> > , CUSTOMERID
> > , CATEGORY
> > , CLOSED
> > , "OPEN"
> > , LATEST_VAL
> > , VALUEDATE
> > , CURRENCY
> > , START_DATE
> > , APPLICATION_DATE
> > FROM PRODUCTS
> >
> > I have purchased the latest source code to try and ensure that
there
> > cannot be problems - having previously used the demo version.
Having
> > deinstalled the demo version and changed the library references I
> > still have the same errors.
> >
> > All very depressing. Any help appreciated as to what the issue
is as
> > have spent hours on what appears to be stock functionality.
> >
> > Otherwise very impressed - Jason!
> >
> > Francis Moore
> >
> >
> >
> >
> >
> >
> >