On 2 Oct 2001, at 15:35, Jason Wharton wrote:

> > I think that's the problem: "the dialect of the db is 3". You must
> > connect to it using dialect 3 also.
> > Check the property "SQL Dialect" in you TIB_Connection.
>
> That won't be the problem because as a part of getting a connection IBO
> asks the database to tell it what it is and this overrides what that is set
> to. The only time you need to actually set it to something is if you are
> calling CreateDatabase so that it knows what dialect to create it as.

The column is defined as

"MSG_DATE" DATE NOT NULL

the data appears as 9/19/01 format. What could be the conflict here,
does anyone else use a datatype of DATE ?

Peter