At 10:09 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?
> >
>
>Before it was Version 5.6 and now it's Version 6 with Dialect 3.
>
> >
> > >and changed the TIMESTAMP-columns to
> > >DATE-Type.
> >
> > Are you saying you had TIMESTAMP columns in the previous version?
>
>No, in Version 5.6 the columns were DATE (the old DATE-TYPE). After
>conversion to Version 6 these columns are TIMESTAMP and then I changed the
>type to DATE (the new DATE-Type)
>
> >
> >
> > >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?
>
>The same.

Then your IB_Query is still trying to pass the old DATE type, is my guess,
i.e. it is expecting a different structure.

If you have a schema cache, DELETE IT.

Then..

Assuming this is a DSQL statement (i.e., not a call to a SP):

What happens if you do this? (in the IDE)?

Double click on the IB_Query.
Click the Prepare button.

Try to inspect the data page.

If it's a SP, with the old DATE column declared as a parameter or a
variable, you would need to drop the SP and create it again, so that it
will compile with the correct structures.

Helen






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