Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Application with and without transactions |
Tue, Jul 27 2010 1:34 PM | Permanent Link |
Jose Eduardo Helminsky HPro Informatica | Tim
I have two situations: First TableList := TStringList.Create; TableList.Add('MyTable); Database.StartTransaction(TableList); Table.Delete; Database.Commit. Second Table.Delete; In the first case only the table MyTable will be locked during transaction. In the second, there is no transaction and then the engine will put a lock on entire database ? Eduardo |
Tue, Jul 27 2010 1:54 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Eduardo
Only the table you're deleting from will be locked. Roy Lambert [Team Elevate] |
Wed, Jul 28 2010 4:34 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Only the table you're deleting from will be locked. >> And I would like to add - only *very* briefly. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Jul 29 2010 6:34 AM | Permanent Link |
Jose Eduardo Helminsky HPro Informatica | Roy and Tim
Thanks for the answers. I don´t know where my head was when I asked this. This is so basic but sometimes I fall just with small rocks. Thanks anyway. Eduardo |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |