I have changed the default value of TIB_Connection.SQLDialect from 1 to 3.

This will begin to be stored in the DFM regardless of its value as I removed
the default clause from the SQLDialect property declaration. However,
because it was there in the past and was set to 1, what will happen now is
people will have it changed to 3 on them.

This may sound kind of bad, but I'm doing a full point release and this will
be in the release notes. Another reason I think this is fine is because
once the database is connected to the SQLDialect is set to whatever the
database actually is.

Regards,
Jason Wharton

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of firebird@...
> Sent: Wednesday, July 12, 2006 8:03 PM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Quoted object names in TIB_Script component
>
>
> > -----Original Message-----
> > From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On
> Behalf Of Helen Borrie
> > Sent: Wednesday, July 12, 2006 8:13 PM
> > To: IBObjects@yahoogroups.com
> > Subject: Re: [IBO] Quoted object names in TIB_Script component
> >
> >
> > At 07:25 AM 13/07/2006, you wrote:
> > >CREATE GENERATOR XYZ works fine in the IB_SCRIPT
> component, but CREATE
> > >GENERATOR "Xyz" gets a "Token unknown" error.
> > >
> > >SQL Manager (www.sqlmanager.net) executes with the quoted name just
> > >fine.
> > >
> > >Is this a restriction in TIB_Script or a bug?
> >
> > It depends. First do a reality check to make sure that the database
> > that your IB_Script is accessing is Dialect 3. Quoted identifiers
> > are unknown tokens in Dialect 1 databases.
> >
>
> And that was it! I did SET SQL DIALECT 3; before the CREATE DATABASE
> and all was well.
>
> Which brings up another question: In "The Firebird Book", pg
> 233, it says
> that Firebird always creates a dialect 3 database by default, which is
> why I left it out in the first place. And just to be on the
> safe side,
> I had set the SQLDialect property to 3 in the TIB_Connection
> object that
> was associated with the TIB_SCRIPT.
>
> Why would it have created a dialect 1 database, absent the
> SET SQL DIALECT
> command?
>
> Michael D. Spence
> Mockingbird Data Systems, Inc.
>