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??