Looks to me like you've put a ';' where you probably intended to put a ','. Is that it per chance? There is no command 'PAGE_SIZE' AFAIK - it's only a parameter to CREATE.

Eddie

----- Original Message -----
From: Uwe Oeder
To: firebird-support@yahoogroups.com
Sent: Wednesday, March 17, 2004 8:37 AM
Subject: [firebird-support] Create Database


Please point out the obvious to me why PAGE_SIZE is not anymore recognised
in the create database statement. Did I go over a limit or something. Oddly
it does still create the database file and gfix reports no errors.

C:\Firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE 'D:\Test2\Data.FDB'
CON> user 'sysdba'
CON> password 'masterkey' ;
SQL> PAGE_SIZE = 8192
CON> DEFAULT CHARACTER SET NONE ;
Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 1
-PAGE_SIZE
SQL>
SQL> -- Select the database
SQL>
CON> CONNECT 'D:\Test2\Data.FDB'
CON> user 'sysdba'
CON> password 'masterkey' ;
Commit current transaction (y/n)?y
Committing.
Database: 'D:\Test2\Data.FDB', User: sysdba

[Non-text portions of this message have been removed]