Hej,
i've tested your db creation script with flamerobin, executing it blockwise:
- creating tables: OK
- creating generators, NOT setting the values: OK
- creating triggers: OK
- creating foreign key: NOK
following are failing with : incompatible data type:
ALTER TABLE TBSETTINGS ADD CONSTRAINT
Created a new database using deZign. The resulting script was run using IB_SQL,
which reported "Script completed without exceptions".
Ran the script using my standard creation checklist, which can be viewed at
http://secure.enw-ltd.com/dbCreation.html#ibsqlCreation.
On committing there was an I