NetTalk Central

Author Topic: One application with multiple databases  (Read 8830 times)

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: One application with multiple databases
« Reply #15 on: April 07, 2015, 04:38:41 PM »
1. With your sql files .. Do you have one that has the Mars+.. stuff on it, that you purposely open once the dbowner value is set?

> no, I just use the field in the FM3 template to set and it works well.

2. Pretty sure I read that you use FM3 (maybe in another thread) .. If you do, how do you handle upgrades when the db structures have changed?

> some of my apps just convert using fm3

  - My thinking atm is to create a separate app which cycles through the tps file company dbowner values and runs the upgrades.

> yeah I also do that which runs the fm3 app that opens all tables

Stu

  • Hero Member
  • *****
  • Posts: 510
    • View Profile
    • Email
Re: One application with multiple databases
« Reply #16 on: April 07, 2015, 11:44:06 PM »
Cheers, thanks muchly Kevin.
Cheers,

Stu Andrews