On 3 Oct 2001, at 11:34, Helen Borrie wrote:

> >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 ?
>
> Are you sure that the gds32.dll on your client machine is not a 5.x
> version?

I have two gds32.dll

c:\windows\system
f:\Program Files\Borland\InterBase\Backup

Both are version 6.0.1.6 , the one in the windows dir has a later date

> If IBO won't connect your database as Dialect 3, check the version on
> the gds32.dll file on the client machine.

The DLL version looks okay

> In which case, the general SQL error comes from passing a date-only literal
> to a type that requires a date + time literal.

So are you saying that even though I have created the GDB as dialect
3, and defined a column as datatype DATE, because it is dialect 3, it
expects the datatype to be TIMESTAMP ?

> CREATE TABLE "PAPURI"
> (
> "CARRIER" VARCHAR(10) NOT NULL,
> "MSG_DATE" DATE NOT NULL,
> "MSG_TIME" TIME NOT NULL,
> <---------------------------------------------------------- "TEXT_MESSAGE"
> BLOB SUB_TYPE TEXT SEGMENT SIZE 400 );
>
> OTOH, in Dialect 3, you can't pass a date literal to the date and time
> types, you have to cast it:
>
> UPDATE MYTABLE SET MYDATECOL = CAST('9/19/01' as DATE)

I tried the CAST statement, but same error.

> FYI, The DATE type of Dialect 1 is equivalent to the TIMESTAMP type of
> Dialect 3. Dialect 1 doesn't have a TIME type. In Dialect 3, the DATE
> type is date-only.

Where can I reda up on datatypes, the IBConsole help is not deep
enough.

> Also, I don't think BLOB SUB_TYPE TEXT is valid DDL either. BLOB SUB_TYPE
> 1 is what you specify for text blobs.

Okay, but consider the following (same data )

IbConsole Blobs can be viewed (opened)
IB_SQL Blobs can be viewed (opened)
IBOQuery Project Blobs can't be viewed

All things being equal, it is the IBOQuery, or more to the point, I'm
learning Delphi, so pls pardon my ignorance of where to look.

The TDBGrid dataset value is IBOQuery.

Peter