At 08:18 AM 28-02-02 +0000, you wrote:

>A simple select raises this everytime. The problem only occurs when I
>select
>the date columns, if left out, it is ok. I am using the latest binary
>for
>Windows and have tried different front ends with the same result.
>
>ISC ERROR MESSAGE: Dynamic SQL Error SQL error code = -804 Incorrect
>values
>within SQLDA structure
>
>Here is the query:
>
>SELECT
>po.ORDERID,po.PURCHASEORDERNO,po.ORDERDATE,po.REQUESTEDRECEIPTDATE,
>po.VENDORID,po.WAREHOUSEID,po.CARRIERID,po.FRTPAYMENTMETHOD,po.ORDERST
>ATUS,p
>o.COMMENTS,
>po.ORDERAMOUNT
>from PORDER po
>order by po.PURCHASEORDERNO
>
>
>Here is the table structure:
>
>CREATE TABLE PORDER
>(
> ORDERID INTEGER NOT NULL,
> PURCHASEORDERNO VARCHAR( 11),
> ORDEREDBY VARCHAR( 11),
> ORDERDATE DATE,
> REQUESTEDRECEIPTDATE DATE,
> VENDORID INTEGER,
> WAREHOUSEID INTEGER,
> CARRIERID INTEGER,
> FRTPAYMENTMETHOD SMALLINT,
> ORDERSTATUS SMALLINT,
> PRINTED SMALLINT,
> COMMENTS BLOB SUB_TYPE 1,
> ORDERAMOUNT NUMERIC( 8, 2) DEFAULT 0,
> NUMBEROFRECEIPTS INTEGER DEFAULT 0,
> CONSTRAINT PK_PORDER PRIMARY KEY (ORDERID)
>)
>
>
>It works if you do not select these date columns:
>ORDERDATE,
>REQUESTEDRECEIPTDATE
>
>
>Any ideas??

One comes to mind - are you using an Interbase 5 or 4 version of gds32.dll
to connect to a Firebird database? Check the version no. of gds32.dll in
your system directory and see whether it matches the server.

HB.


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________