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