I had to face the same problem, First I tried to use a Commitretaining which keeps all Qeries/Tables open but this can lead to deadlock errors, if another application tries to alter ANY of the changed records until I do a commit which de-activates (closes) all Tables.
I helped myself by writing a reopen - procedure which iterates through all open Tables of a Database if it's open, get a bookmark and put Table and Bookmark into a list Do a commit Iterate through the list, re-Open Table and try to position to bookmark, free bookmark relax Hope it helps, hacve fun! Bob > > > After I do an IBTransaction.Commit all data controls seem to loose > their active status. Is there a way to prevent this, or reset them > without having to traverse through all forms etc. > > Delphi 7, using Firebird 1.5 and standard Interbase Components from > Delphi7 ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
