Hi,

I have Firebird 2.01 classic server installed. Using the built-in C
API in standalone (embedded engine fashion) , I can query most
datatypes except DATE, TIME Decimal(18,2) and NUMERIC(18,2).

The engine returns the following messages during prepare:

Prepare stmt failed, sqlcode: -206!
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-DATECOL
-Client SQL dialect 1 does not support reference to DATE datatype


Prepare stmt failed, sqlcode: -206!
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-TIMECOL
-Client SQL dialect 1 does not support reference to TIME datatype

Prepare stmt failed, sqlcode: -206!
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-DECCOL
-Client SQL dialect 1 does not support reference to BIGINT datatype

Prepare stmt failed, sqlcode: -206!
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-BIGINTCOL
-Client SQL dialect 1 does not support reference to BIGINT datatype

I was using SQLDA_VERSION1, but cannot find anything other than
VERSION1 in the ibase.h header file.

Any idea?

jml