Hi All,

I'm getting the above message when trying to execSQL in D5Enterprise
with IBO3.6D. I've searched the list, and the only reference to the
above problem was met with "upgrade to the latest version". I
believe that 3.6D is the latest version.

I have some preprepared SQL:

insert into HL7LINK (GUID_KEY, CREATE_DATE, DELETE_DATE,
PERSON_SEARCH_KEY, LINK_TYPE, LINK_TABLE, LINK_KEY,
ASSIGNING_FACILITY)
VALUES (:GUID_KEY, :CREATE_DATE, :DELETE_DATE, :PERSON_SEARCH_KEY,
:LINK_TYPE, :LINK_TABLE, :LINK_KEY, :ASSIGNING_FACILITY)

With the parameters, I'm only setting those that I want to have
values (ie. not NULL).

The CREATE TABLE code is plain vanilla - column names and datatypes.
Not even an index!


Any ideas?

TIA

Alan Janke
AIMTec
Australia