• Registered: 2015-12-28
  • Posts: 61

Topic: connect to 2 databases

hi gays

can i ,by script ,connect to an other database and read /write data from it without loosing connection to the first database?

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

Re: connect to 2 databases

Hello,


You can attach other sqlite database file:

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

using:

SELECT TEST.person.firstname, TEST.person.lastname FROM TEST.person
Dmitry.
  • Registered: 2015-02-24
  • Posts: 446

Re: connect to 2 databases

Nice info !!


I'll keep that in my snippet manager big_smile

I'm a very good housekeeper !
Each time I get a divorce, I keep the house
Zaza Gabor
  • Registered: 2015-12-28
  • Posts: 61

Re: connect to 2 databases

thank you
it is a great software