Subject Re: [firebird-support] Re: Error creating Foreign key
Author Mourad Hedfi
Post date 2018-06-13T06:47:27Z
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 problem occurs.

The commands SQL are exectued in a transaction witch is commied or rollabaked at the end.

"You must use "wait" transaction for metadata changes. " ==> What command I must add for that ?

Bien cordialement.

Mourad Hedfi
Directeur de projets
Tél. : 01 83 62 36 85

2018-06-12 15:44 GMT+01:00 blackfalconsoftware@... [firebird-support] <firebird-support@yahoogroups.com>:
 

If you are not getting this issue with FlameRobin than this may be an issue with the Firebird compiler that creates the binary form of the database object scripts.

Hopefully one of the database developers such as Helen or Mark can shed some light on this...