Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One software Multi-companies
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01457588
Message ID:
01457670
Views:
55
>From Sergey's message I presume that he is not much in favor of putting records of multiple companies into the same tables. And I thought of another approach you might want to consider. Probably much more involved but still an alternative. You could have a suffix number added to the database container and all tables for each company "database". E.g. Database01.d??, TableA01.dbf, Table01, Database02.d?? and so on. Then whenever you open a database or a table you would need to have the code to use the name with the appropriate company suffix.
>
>HTH.

I'm not sure where did you get this impression, but, IMHO, this new idea is much worse than having records for different companies stored inside the same centralized database.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform