I regularly find myself having to merge two (or more) records referenced by numerous foreign keys... resulting in having to update many tables to perform this merge. I would find it really useful if there was (and maybe there already is and I just didn't found it) a way to do this in one update (performing the cascade).
If I am not the only one who would consider this useful, I will gladly add a ticket for this... I just didn't want to "pollute" the tracker with something I would be the only one finding it useful. Example : Table Patient with a sequence ID often has duplicate (after two clinics merge or simply data entry error) but has numerous dependant tables referencing this ID. Evelyne ------------------------------------------------------------------------------ Start Your Social Network Today - Download eXo Platform Build your Enterprise Intranet with eXo Platform Software Java Based Open Source Intranet - Social, Extensible, Cloud Ready Get Started Now And Turn Your Intranet Into A Collaboration Platform http://p.sf.net/sfu/ExoPlatform Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
