Subject SQLWhere
Author Francis Moore
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