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;

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

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

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

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

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