Hi Allan

>If you always and only do a CommitRetaining, you will always be retaining
>the transaction context. You should (must) more often do a Commit and move
>the transaction along. I most always Commit and keep CommitRetaining to a
>miminum.
>
>Alan
>
>

Thanks for the info. If you do commit most of the time, then you open
the table/transaction most of the time also? Do you commit on every
record that was save? Let us say that the application was used by many
client and viewing the most updated records are critical.

Thanks.

James

>
>
>
>
>Yahoo! Groups Links
>
>To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
>To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>
>
>
>
>