Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
How to obtain a whole database lock? |
Tue, Sep 3 2013 12:26 PM | Permanent Link |
Richard | I need to lock the whole database while I alter tables, indexes etc.
I am using Delphi and would like ideally EDBDatabase.Exclusive:=True; try EDBDatabase.Open; try // alter tables // create indexes // backup etc. finally EDBDatabase.Close; end; except on E: EUnableToLockDatabase do ShowMessage('Database Is Currently In Use, Unable To Proceed'); end; |
Tue, Sep 3 2013 2:15 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Richard,
<< I need to lock the whole database while I alter tables, indexes etc. I am using Delphi and would like ideally >> I'll see what I can do. It's not difficult to implement since EDB already supports opening databases exclusively in the engine. Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 4 2013 4:56 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< I need to lock the whole database while I alter tables, indexes etc. I am >using Delphi and would like ideally >> > >I'll see what I can do. It's not difficult to implement since EDB already >supports opening databases exclusively in the engine. If that allowed multiple cursors on a table that might make a great single user switch. Roy |
Wed, Sep 11 2013 1:33 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< If that allowed multiple cursors on a table that might make a great single user switch. >> I don't have any idea what that means...care to elaborate ? Tim Young Elevate Software www.elevatesoft.com |
Thu, Sep 12 2013 3:15 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
<< If that allowed multiple cursors on a table that might make a great >single user switch. >> > >I don't have any idea what that means...care to elaborate ? In my app I have a table Companies - that will be opened and displayed on its own page, I may have a second instance open (luCompanies) to check / display the parent company for a company, and a third instance open to show competitors etc Roy Lambert |
Tue, Sep 17 2013 1:07 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< In my app I have a table Companies - that will be opened and displayed on its own page, I may have a second instance open (luCompanies) to check / display the parent company for a company, and a third instance open to show competitors etc >> Ahhh, yes, that would still be allowed. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |