Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Free Tables and Database At the Same Time
Message
 
 
To
12/06/2001 11:56:26
Valter Herman
Tuesday Morning, Inc.
Dallas, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00518449
Message ID:
00518459
Views:
11
>I've acquired a software project 9 months ago using VFP that accesses data using free tables as opposed to a database. Among the many clean-up activities we'd like to perform on this project is wrapping up all the free tables in a database and changing the many modules (exe's) of this project to use the database. Ideally, we'd like to change one exe at a time to use the database. Is it possible (and advised) to have one VFP-created exe access a set of free tables at the same time another VFP-created exe is accessing the same tables but through a database?
>
>Thanks,
>
>Valter

Yes you can. What you can do is create a local view of every free table without adding the actual table to the DBC. Name each of the views exactly the same as the free table name. Once all the EXEs are in place, you should be able to remove the views and add the tables to the DBC without changing any code.

Once you get the local views created, you can then create other parameterized and other more complex views based on your free-table local views.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform