At 09:33 PM 21-01-01 +0100, you wrote:

>I have converted my DB to IB6

What version was it before conversion? Which dialect are you trying to
use? What do you see in the SQLDialect property of the IB_Connection?

>and changed the TIMESTAMP-columns to
>DATE-Type.

Are you saying you had TIMESTAMP columns in the previous version?

>With IBConsole I can open the tables, but when I try to open
>the altered tables with a IB_Query, I get the error
>Dynamic SQL Error
>SQL error code=-804
>Incorrect values within SQLDA structure

What do you see in your IB_Monitor?

>Any ideas, what I have done wrong ?

No - more information would help.

H.

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________