Thanks!

I'm fixed (for now) :)

I'm transitioning from MySQL and SQLite.

Jeff

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 02:55 AM 17/09/2006, you wrote:
> >Howdy,
> >
> >I'm working my way through Borrie's Firebird Book, and have hit a
> >weird roadblock with scripts. This script:
> >
> >SET SQL DIALECT 3;
> >CREATE DATABASE 'c:\databases\test.fdb'
> > PAGE_SIZE 8192
> > DEFAULT CHARACTER SET ISO8859_1
> > USER 'SYSDBA' PASSWORD 'masterkey';
> >
> >fails with:
> >
> >Dynamic SQL Error
> >-SQL error code = -104
> >-Token unknown - line 4, char 2
> >-USER
> >SQL>
> >
> >I've created the script with both notepad and vi (on a connected linux
> >system) - it ends with several blank lines. I'd appreciate the loan of
> >a clue :)
>
> Try it with the arguments in this order:
>
> SET SQL DIALECT 3;
> CREATE DATABASE 'c:\databases\test.fdb'
> USER 'SYSDBA' PASSWORD 'masterkey'
> PAGE_SIZE 8192
> DEFAULT CHARACTER SET ISO8859_1;
>
> And, darn, I thought this had been fixed...I sense another erratum
> coming along...
>
> And I've found a small (no-impact) bug in SHOW DATABASE while testing
> this. Hmmm.
>
> ./heLen
>