Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get a checksum sort of for the app folder/placeme
Message
 
To
11/10/2005 14:57:03
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
01056670
Message ID:
01059018
Views:
29
Hi Dorin

Maybe you had meant it this way but I couldn't understand it, here is my take on this thread.

Development Machine:
Create an ODBC: C13_VSO3Data_FB
Open Database
Create Connection: C13 and make it use C13_VSO3Data_FB as source
Create Remote Views based on the "Connection" C13 (as opposed to what I have done till date)

Users Machine Copy 1:
Install App
On First Run
1) create an ODBC: C13_VSO3Data_FB_12345 (12345 based on the code generated of the pathanme)
2) Open Database
3) DBSetProp() connection C13 to use C13_VSO3Data_FB_12345 as the source

Users Machine Copy 2:
Install App
On First Run
1) create an ODBC: C13_VSO3Data_FB_67890 (67890 based on the code generated of the pathanme)
2) Open Database
3) DBSetProp() connection C13 to use C13_VSO3Data_FB_67890 as the source

I have tested the theory in the VFP IDE yesterday and was successful, hoping to do the same in the app.

There was a positive offshoot also. Supposing a client wants 2 copies of the software as above, but he wants to share some master data between both the app copies, most probably we can:

Development Machine:
Create an ODBC: C13_VSO3Data_FB_Global
Create an ODBC: C13_VSO3Data_FB_Private
Open Database
Create Connection: C13_Global and make it use C13_VSO3Data_FB_Global as source
Create Connection: C13_Private and make it use C13_VSO3Data_FB_Private as source
Create Master tables Remote Views based on the "Connection" C13_Global
Create Other tables Remote Views based on the "Connection" C13_Private

Users Machine Copy 1:
Install App
On First Run
1) create if not found an ODBC: C13_VSO3Data_FB_Global
2) create an ODBC: C13_VSO3Data_FB_Private_12345
3) Open Database
4) DBSetProp() connection C13_Private to use C13_VSO3Data_FB_Private_12345 as the source

Users Machine Copy 2:
Install App
On First Run
1) create if not found an ODBC: C13_VSO3Data_FB_Global
2) create an ODBC: C13_VSO3Data_FB_Private_67890
3) Open Database
4) DBSetProp() connection C13_Private to use C13_VSO3Data_FB_Private_67890 as the source

Of course there may be practical problems to the above, but my first impression of the theory got me really excited.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform