[firebird-support] I can't drop foreign key.

Hi. I am using FireBird2.5.3,and a dataBase is updated from 2.2, and the database was updated from 1.5. The database have about 150 tables and just one Foreign key. The Foreign key is from "hachu"table to "parts"table. This is a part of definition of the Tables. (ISQL showed these informati

Re: [firebird-support] I can't drop foreign key

Thank you !!! Mark !! Resolved! One procedure referenced the Index; The procedure uses "Plan Sort(Hachu Index(FKHACHUTOPARTS))" in Select SQL. I create other Index HachuP on Hachu(partsid). And I alter the procedure ,not to use plan the FKHACHUTOPARTS to use plan with new Index HachuP.

[firebird-support] Can merge return AffecterRows?

hi,I am Nobuo Watanabe. I use FireBird 2.5.6 and FireBird2.5.3. Firebird2.5Language Reference about 'merge command' says: Currently, the ROW_COUNT variable returns the value 1, even if more than one record is modified or inserted. For details and progress, refer to Tracker ticket CORE-4400

Re: [firebird-support] Can merge return AffecterRows?

Thank you ,Thomas! The count is right.I feel easy. I didn't think there was other ticket. I hope Reference will be changed. Sincerely. On 2016/09/28 22:16, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: > hi,I am Nobuo Watanabe. > I use FireBird 2.5.6 and FireBird2.5