I have a pretty simple SQL statement (replaced some IDs):

Select Log_ID, CODEGIVEN From ClientLog where Client_ID = 123 and
MachineID = 1234 and Expires_DateTime = "25-Feb-2005"

The ClientLog table is pretty simple:

CREATE TABLE CLIENTLOG (
LOG_ID INTEGER NOT NULL,
CLIENT_ID INTEGER NOT NULL,
MACHINEID VARCHAR(16) CHARACTER SET NONE,
EXPIRES_DATETIME DATE,
CODEGIVEN VARCHAR(16) CHARACTER SET NONE,
...
);

yet when I run this SQL from within my program, I get the exception:

Project [AppName].exe raised exception class EIB_ISCError with
message 'ISC ERROR CODE:335544334

ISC ERROR MESSAGE:
conversion error from string "ABCDEFAA"
'. Process stopped. Use Step or Run to continue.

I can't find anywhere reference to 'ABCDEFAA' inside ClientLog. Also,
I can run the SQL statement inside of IBExpert just fine. I am using
a run-time created IB_Query for the select.

Any ideas what might be causing this?

Ed Dressel