Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access to fpw2.6 tables from vfp7
Message
From
25/04/2003 13:53:40
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00781421
Message ID:
00781601
Views:
21
Thank you.
This is all very helpful.

I intend to view the fpw2.6 tables and actually write to them via a vfp7.0 multithreaded dll, which is all running on a win 2k server boxe that hosts IIS ver 4.0. Presently, I read/write to my vfp7 tables via the Internet from this box. I would like to do the same with my fpw2.6 tables. How should I set up the environment on both versions of fox so that both versions can have access to the tables at the same time.

Neil

>I do not see any particular problem, give it a try. In fact, after reviewing my notes, I am not sure you cannot use alter table either. I will try it with some old FP2.5 stuff I got on my system.
>
>Glenn
>
>>Now that sounds like what I am looking for. May I use an exisiting dbc in my vfp project that contains many tables and views and just add views of the free fpw2.6 tables. I use sdt to maintain my dbc.
>>
>>Neil
>>
>>
>>>Of course you can use/read/write to FP2.6 tables from VFP. It is safe and consistant with backward compatability. SQL views are only maintaiuned in a Database Container and therefore the tables cannot be contained in the DBC. It is possible to create a DataBase with nothing but views. These views could be based upon free tables (FP2.6). I did this once 5 years ago while integrating VFP with FP2.5.
>>>
>>>On caveat however is DO NOT alter table with VFP on a FP2.6 table. AFAIK this will modify the header to make the table unusable by FP2.x
>>>
>>>Glenn
>>>
>>>>Hi,
>>>>
>>>>I have a legacy FPW 2.6 application that maintains 19 tables. Is there a way to have a multi threaded vfp 7 dll read and write the fpw tables while the tables are also being read and write by the fpw 2.6 exe. What tricks can I perform that allows me to create views of the fpw2.6 tables.
>>>>
>>>>Neil
Previous
Reply
Map
View

Click here to load this message in the networking platform