Subject Sample IBOQuery (project) questions
Author dba@febc.org.ph
Hi,

When I run IBOQuery (sample app), specify the GDB and press the OPEN
button, I get a message:

Project IBOQuery.exe raised exception class EDBEngineError with
message 'General SQL error.

Column error.
Column unknown
MSG_DATE
Client SQL dialect 1 does not support reference to DATE datatype'.

Click OK, and "Run" and I can view the data.

The metadata for the table is

CREATE TABLE "PAPURI"
(
"CARRIER" VARCHAR(10) NOT NULL,
"MSG_DATE" DATE NOT NULL,
"MSG_TIME" TIME NOT NULL,
"TEXT_MESSAGE" BLOB SUB_TYPE TEXT SEGMENT SIZE 400
);

Also, the TDBGrid won't let me view the BLOB column, it just has
[MEMO], but I can't view the contents. However, I can view the BLOB
data in IBConsole. The dialect of the db is 3.

Thanks,

Peter