Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple companies (database) and SDT
Message
From
27/03/2010 11:50:43
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Stonefield
Title:
Multiple companies (database) and SDT
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01457601
Message ID:
01457601
Views:
105
What would be the best way to make a software multi-companies. I use Stonefield Database Toolkit. Would SDT make things easier?

Let me give you more details and why I see SDT involved in this.

Multi companies means multiple copies of the database that I have right now.

For example right now in my code I do "Set database to..." and that's it. My application runs fine.

I'd like to give the possibility to the user to specify which database (company) to use.

SDT is letting me do something really nice and that is to update a customer's database structure automatically. That means that whatever changes I do they go into metadata files. When I copy those files on a client's machine his database structure is adjusted to reflect the new structure I have on my computer.

I guess that multi-companies would be done within the application. That is the user wants to create a new company then I create a copy of the database to another DB and in the future when the app is launched I ask which company needs to use the app. That's why I'm wondering if SDT could still manage this multi-companies thing.

So I'm wondering what would be the best moves to make my application work for multi-companies.
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Next
Reply
Map
View

Click here to load this message in the networking platform