Subject Re: [ib-support] PROBLEM SELECTING DATE COLUMNS
Author Paul Reeves
abizafu 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
>

I pasted in the create table statement in ISQL and then tried the select
statement. It executed without raising an error. Obviously no data was
returned because none had been entered. I created some test data and
inserted it. Reran the query and still no problems.

Can you confirm the actual version of Firebird or InterBase that you
used? I tested on a post-RC2 build of Firebird.


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further