Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't open a table exclusively
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00313297
Message ID:
00314577
Views:
42
Paul,
According to VMP, the tables are opened to a) make sure all tables are available and not corrupted and b) to speed form loading since the forms do a USE AGAIN if they find the table in the default data session.

I have had no problems with commenting out the code that opens these tables, and I've used 2 versions of VMP on 4 projects. One has been running for 2 years now 24X6, with 1000 records per day added to each of 5 tables.

The major reason for NOT doing it the VMP way is that you're never sure when opening a table, even with USE MyTable, if you're getting the latest data from the server.

Barbara

>Thanks for the input here Barbara,
>
>I have wondered why VMP opens all of the data in the default data session when we still have to open up the tables we need in each of the forms. Do you know why they do this? I guess your suggesting not opening all of these tables, except appinfo, in the default data session. This makes sense to me, I would also think this would speed up application startup. Are there any concerns I might want to think about prior to making this change in ctrPAApp that you can think of?
>
>Thank you very much,
>
>Paul
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform