I have my transaction for 50 TIBTables. If I Commit it, then I close all 50 tables and have to open these again.

Is it a good approach to have another transaction, only for new records, that I commit imediatly ?


Thank you,
Tiberiu

----- Original Message -----
From: Martijn Tonies
To: firebird-support@yahoogroups.com
Sent: Friday, August 12, 2005 6:29 PM
Subject: Re: [firebird-support] deadlock




> I do
>
> Transaction.CommitRetaining;
>
> after each post.

This does not end the transaction.

Only a "Commit" does.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




SPONSORED LINKS
Technical support Computer security Computer technical support Computer training Free computer technical support

---------------------------------
YAHOO! GROUPS LINKS


Visit your group "firebird-support" on the web.

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

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


---------------------------------



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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