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 TBSAVEDQUERIES_TBSETTINGS
FOREIGN KEY (FKSAVEDQUERY) REFERENCES TBSAVEDQUERIES (KSAVEDQUERY) ON DELETE CASCADE;

ALTER TABLE TBIMAGECOLL ADD CONSTRAINT TBCONTACTS_TBIMAGECOLL
FOREIGN KEY (FKCONTACTS) REFERENCES TBCONTACTS (KCONTACTS) ON DELETE CASCADE;

ALTER TABLE TBIMAGECOLL ADD CONSTRAINT TBIMAGES_TBIMAGECOLL
FOREIGN KEY (FKIMAGE) REFERENCES TBIMAGES (KIMAGE) ON DELETE CASCADE;

ALTER TABLE TBSAVEDQUERIES ADD CONSTRAINT TBCONTACTS_TBSAVEDQUERIES
FOREIGN KEY (FKCONTACTS) REFERENCES TBCONTACTS (KCONTACTS) ON DELETE CASCADE;


jwcane2003 wrote:

> 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 IBO hourglass icon for at least 30 s.
>
> Repeated the "Commit" action; this generated Windows-7 progress wheel, followed by the IB_SQL message containing the words, "ISC deadlock".
>
> Exploration of status details revealed inability to format a message. I will be rebooting and re-installing Firebird in order to address this error.
>
> On attempting to disconnect and/or close IB_SQL I got the prompt, "Please complete your transaction".
>
> In the meantime, if anyone can see any errors in the SQL script,I would appreciate knowing that. Script is available at http://secure.enw-ltd.com/create_firebird.sql.
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>