• From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Topic: Connect database

Hello... how to connect mvd application with sqlite database using script... and how to load data in tablegrid using script...

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 895

Re: Connect database

Hi,
connect to another SQLite database:

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

and use in the program

SELECT TEST.person.firstname, TEST.person.lastname FROM TEST.person
  • From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Re: Connect database

Thanks...
But i need complete procedure to connect and retrieve data..
I mean connection strings, query procedure ,loops, load data in table grid using script

4 Reply by sibprogsistem (edited by sibprogsistem 2022-01-31 04:40:10)

  • From: Нефтеюганск
  • Registered: 2018-04-11
  • Posts: 1,775

Re: Connect database

blackpearl8534 wrote:

Thanks...
But i need complete procedure to connect and retrieve data..
I mean connection strings, query procedure ,loops, load data in table grid using script


// отключаемся от старой БД
frmStart.SQLConnection.Connected := False;
// подключаемся к новой БД
frmStart.SQLConnection.Params.Add('Database='+listBox.Items[listBox.ItemIndex]+'\sqlite.db');