• Registered: 2017-05-15
  • Posts: 723

Topic: two database within 1 project

Hello MVD!

Pls help and give a sample of two database within 1 project.  Is this possible?

Thanks!

  • Registered: 2014-02-14
  • Posts: 10,294

Re: two database within 1 project

Hello.


You can attach other sqlite database file:

SQLExecute('ATTACH DATABASE ''testDB.db'' as ''TEST''');


using only by script:

SELECT TEST.person.firstname, TEST.person.lastname FROM TEST.person
Dmitry.
  • Registered: 2015-11-13
  • Posts: 652

Re: two database within 1 project

Manix,
I threw together a quick and dirty project to demonstrate the use of an attached SQLite database as a second database using the commands Dimtry has shown. Keep in mind that to manipulate an attached database you need to use SQL because MVD does not recognize it in it's normal process.  I tried to somewhat mock what MVD does in updating the database.  Hope it helps

Post's attachments

Attachment icon Two Databases.zip 585.18 kb, 361 downloads since 2017-08-25 

  • Registered: 2017-05-15
  • Posts: 723

Re: two database within 1 project

Thank You DriveSoft and EhWaganer...

It helps me a lot to my project.....

Thanks 3!