--- Francis Moore <moorefg@...> wrote:

> 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
> > >
> > >
> > >
> > >
> > >
> > >
> > >
>
>

=====
Yrd. Do�. Dr. Ali ATES

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/