Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Persistence of open DBF's using in-process VFP COM serve
Message
From
25/01/2000 08:36:15
 
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00321574
Message ID:
00322120
Views:
25
>>You have to explicitly close the tables.
>
>Thanks, Craig. Tell me, what if you do the following:
>- in one ASP page say: oMyVFPObject=Server.Createobject(etc.etc)
>- in its INIT, oMyVFPObject opens MyData.DBF with something like: USE MyData ALIAS MyAlias
>- that ASP page completes and the object is destroyed, but table is not explicitly closed by my VFP code
>- then try and do those same steps all over again... will you get an error like "Alias name is already in use" or something like that... in other words, the table stays opened by the DLL across all instances of objects born out of that server?

I open and close the tables in each method. If you want to do things you're way, wrap the USE around:

IF !USED("Alias")
USE Table IN 0
ENDIF


>
>Also, what if you put a QUIT command in an in-process MT VFP DLL?

Are you saying you use the QUIT command? I've never put it in an MTDLL.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform