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