Hello,

I have a problem when executing the following script with TIB_Script or
for test purposes in IB_SQL.

SET SQL DIALECT 1;

SET NAMES WIN1252;

CREATE DATABASE 'g:\winbuch_log.fdb'
USER 'sysdba' PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET WIN1252;

/* Logging metadata script generated at 24.09.2008 16:24:54 with IB
LogManager v2.9.0.2 */
/* Use this script on a DIALECT 1 database only */
/* CHANGE THIS SCRIPT ON YOUR OWN RISK! */


/* NOTATIONS: IBLM$METADATA */
CREATE TABLE IBLM$METADATA (
NOTATION VARCHAR(31) NOT NULL,
NOTATIONVALUE VARCHAR(31) NOT NULL,
CONSTRAINT PK_IBLM$METADATA PRIMARY KEY (NOTATION));
COMMIT WORK;


/* OPERATIONLOG: IBLM$OPERATIONLOG */
CREATE TABLE IBLM$OPERATIONLOG (
ID INTEGER NOT NULL,
DATUMUHRZEIT DATE NOT NULL,
BENUTZER VARCHAR(31) NOT NULL,
TABELLE VARCHAR(31) NOT NULL,
OPERATION VARCHAR(6) NOT NULL,
PKEY1 VARCHAR(31),
PKEY1_VALUE VARCHAR(20),
PKEY2 VARCHAR(31),
PKEY2_VALUE VARCHAR(20),
PKEY3 VARCHAR(31),
PKEY3_VALUE VARCHAR(20),
PKEY4 VARCHAR(31),
PKEY4_VALUE VARCHAR(20),
PKEY5 VARCHAR(31),
PKEY5_VALUE VARCHAR(20),
CONSTRAINT PK_IBLM$OPERATIONLOG PRIMARY KEY (ID));
COMMIT WORK;


I get the following error message:

ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -817
Metadata update statement is not allowed by the current database SQL
dialect 1

STATEMENT:
TIB_DSQL: "<TApplication>.frmSQL.frmScript.IB_Script.<TIB_DSQL>."


Any ideas? I don't see the obvious problem, e.g. DATE is supported in
dialect 1 ...

I'm using IBO 4.8.7 and Firebird 2.1.


Thanks!


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/