SQL Error creating end user table with CreateEndUserTables.sql In IB Database

rbuser

Hi !
The CreateEndUserTables.sql script return an error
with this statement :

CREATE TABLE rb_item
(item_id INTEGER NOT NULL AUTOINCREMENT, <----
folder_id INTEGER NOT NULL,
item_name VARCHAR(60) NOT NULL,
item_size INTEGER,
item_type INTEGER NOT NULL,
modified DOUBLE NOT NULL,
deleted DOUBLE ,
template VARBINARY, <------
PRIMARY KEY (folder_id, item_type, item_name, modified) );

Autoincrement return an invalid token error
and
VARBINARY Return 'Invalid command. Specified domain or source colums
VARBINARY does not exist.

Is there Someone who have a correction for this script ?

I'm using Report builder for Delphi 6 V 10.07 / Firebird V 1.53


Regards

Didier

nardmoseley

A customer using RB and Firebird recently sent us the following SQL script..

www.digital-metaphors.com/tips/RBEndUserTablesForFirebird.zip




--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com