Mensaje
De
28/03/2010 10:47:37
a
27/03/2010 13:06:05
General information
Foro:
Visual FoxPro
Category:
Programación, sintáxis y comandos
Título:
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
ID de la conversación:
01457588
ID del mensaje:
01457668
Views:
63
>>>What would be the best way to make a software multi-companies. I use Stonefield Database Toolkit. Would SDT make things easier?
>>>
>>>Overall Feedback?
>>
>>Hi Denis,
>>
>>I definitely would recommend SDT. I have a vertical market application used by many different companies. And I use SDT in such way that even though the database is the same, different tables can have custom fields (additional fields) without me having to customize the application.
>
>Hi Dmitry,
>
>Yes it could be a way to do it but what about creating multiple databases. 1 database per company. How could SDT manage this? Would it be able to still to manage this with the updates and everything?
>
>By the way I created another thread in the Stonefield category. You can also reply there if you want. I thought creating it in that category would be better suited for my problem.
>
>Thanks
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.
>>>
>>>Overall Feedback?
>>
>>Hi Denis,
>>
>>I definitely would recommend SDT. I have a vertical market application used by many different companies. And I use SDT in such way that even though the database is the same, different tables can have custom fields (additional fields) without me having to customize the application.
>
>Hi Dmitry,
>
>Yes it could be a way to do it but what about creating multiple databases. 1 database per company. How could SDT manage this? Would it be able to still to manage this with the updates and everything?
>
>By the way I created another thread in the Stonefield category. You can also reply there if you want. I thought creating it in that category would be better suited for my problem.
>
>Thanks
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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham