Did this get resolved for you? Is there anything more you have a concern
about?

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "James Bunting" <jpb@...>
To: <IBObjects@egroups.com>
Sent: Thursday, January 04, 2001 9:50 AM
Subject: Re: [IBO] Switching Dialects


> > You don't change the dialect this way. Dialect is actually structural
and
> > tied to the dataset. The reason you can set that is if you were about to
> > call the CreateDatabase method.
>
> The database is a IB6 database and I can connect, but if I do the
> query SELECT * FROM MYTABLE, I get an error saying:
>
> "Data type unknown. Client SQL dialect 1 does not support
> reference to DATE datatype"
>
> However, I can do the same query using IBX and IBConsole and it
> works. That's why I was trying to manual set the Dialect, as we are
> using Dialect 3 data types.
>
>
> James Bunting
>
> Systematic Marketing Ltd
> http://www.systematicmarketing.com
> http://www.ukindex.co.uk
>
>
>