Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multi-company system
Message
De
18/03/2019 04:13:06
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
 
 
À
06/03/2019 14:27:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2012
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01667024
Message ID:
01667319
Vues:
128
>Generally speaking, each company would be in its own database. You would open the database in that company's directory. If you have shared resources that are distributed among all the various companies, these can be in another database.

Unless using .DBF files it's not an easy approach database per company. If you use SQL Server DB best approach is add a company field for each table for separate companies. Axapta and SAP uses this approach. So you can create company based or mixed reports easly, or you can make address and person tables public, others private etc...

Axapta and SAP also have another field to separate company groups.

Of course you can't use this approach with .DBF files because of 2GB barrier.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform