Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-company system
Message
From
07/03/2019 09:16:18
 
 
To
06/03/2019 14:27:00
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2012
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01667024
Message ID:
01667076
Views:
91
Likes (1)
Why have multiple databases? If you have multiple databases, then you have to manage the changing between them based on Company. I would add a field (companyid) to each table record key for the tables that are shared between the companies; i.e., the record key is now comprised of multiple fields (id and companyid). This key field will separate the records by company. Tables that are shared across companies; i.e., lookup tables, do not have the company key (unless each company can have a different configured list of values). Then create a custom property on _VFP as follows:
ADDPROPERTY(_VFP, "CompanyId", "")
Now set this property value for the current company. Then use this property value in the SELECT statements to retrieve the records that are applicable to the current selected company. This same functionality is used in SAP R/3 and S/4HANA to separate between client systems and has worked very well for decades.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform