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