Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pack Database with OLEDB ?
Message
 
 
To
13/11/2001 17:31:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00581175
Message ID:
00581497
Views:
23
Steve,

>Hello Steve,
>
>I think the only way to accomplish that task would by calling a stored procedure.

Can a stored proc in a DBC pack the DBC itself? I guess I have never tried that... Wait, let's give it a try...

Nope...I get an error: "A stored procedure is executing (Error 1538)" when I try to use a stored proc to pack the database itself...a PACK must try to close everything (including terminating stored procs) before packing, and it can't because the pack proc is still running...

Packing a table should work OK I would think, but packing the database might be a bit tricky. Is there a reason you need the DBC packed at runtime? Seems like more a development-time process...?

JoeK
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform