Maybe you should report this to IB group, what Bob does works but it's
not the right way to do it right? lot of extra work...

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 23, 2005 9:04 PM
To: [email protected]
Subject: Antwort: [delphi-en] Data controls go inactive after
IBTransaction.Commit


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 Sponsor
            ADVERTISEMENT





----------------------------------------------------------------------------
----
Yahoo! Groups Links

  a.. To visit your group on the web, go to:
  http://groups.yahoo.com/group/delphi-en/

  b.. To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]

  c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




[Non-text portions of this message have been removed]



-----------------------------------------------------
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/
 



Reply via email to