Re: [firebird-support] Re: Error creating Foreign key

2018-07-17 Thread Mourad Hedfi mou...@bilog.fr [firebird-support]
Hello, I come back because I've upgrade Firebird to 2.5.8 but the problem of creating foreign keys always persists. In fact, the problem occurs after executing commands for insert, update and delete data and after that I exectue command to create FK. I've found that when I've two or more FK for

Re: [firebird-support] Re: Error creating Foreign key

2018-06-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.06.2018 8:47, Mourad Hedfi mou...@bilog.fr [firebird-support] wrote: > "You must use "wait" transaction for metadata changes. " ==> What command I > must add for > that ? https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-transacs-statements.html

Re: [firebird-support] Re: Error creating Foreign key

2018-06-13 Thread Mourad Hedfi mou...@bilog.fr [firebird-support]
Thanks for your suggestions. The database file is not in use and I can rename. I've tried to drop / create FK without executing update commands and it works fine. After that, I've executed to whole process : 1. DROP FK 2. Execute insert / update / delete SQL commands 3. Create FK ===> the