At 05:21 PM 04-10-01 +0800, Peter Richards wrote:

> >
> > 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

After you have __connected__ to the database using IB_SQL, what dialect is being reported on the Connection tab?

>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 ?

No. If you have __actually__ got a dialect 3 database, a column defined as DATE will be a dialect 3 DATE type. If your database is in fact a dialect 1, a column defined as DATE will be the equivalent of TIMESTAMP.

> >
> > 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.

What EXACTLY is the error message?

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

In the Data Definition manual, the section on datatypes.

>
> > 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

What kind of control are you trying to view the blob column in? A TDBGrid? AFAIK, the VCL TDbGrid doesn't support displaying blobs in a grid. Display a TDBMemo alongside the grid, linked to the same datasource and to the blob datafield; then, as you scroll through the grid you will see the contents of the blob field.

NB, make sure that you instantiate the virtual field objects of your dataset (set the query Active, then dbl-click on the iboquery, right-click on the window and select Add All Fields.) Select the blob field and, if necessary, change its FieldType to ftMemo.

>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.

No, the DBGrid must be linked through its Datasource property to a TDatasource. This TDatasource in turn must be linked to your dataset through its Dataset property. Or is this what you meant?

Helen