• From: Philippines
  • Registered: 2018-10-23
  • Posts: 430

Topic: Run UpdateDatabase Manually

Hello MVD Wizards.

Is it possible to disable UpdateDatabase('') function to run background, I mean when the system starts?

I want to run it manually after showing my Main Form for having bulk data makes login form to show very late.

I done it on mysql using the disable_connectdialog but how can I do such thing on sqlite?

Thank you in advance.

brian
  • From: Philippines
  • Registered: 2018-10-23
  • Posts: 430

Re: Run UpdateDatabase Manually

up

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

Re: Run UpdateDatabase Manually

frmStart.SQLConnection.Connected := False;
  • From: Philippines
  • Registered: 2018-10-23
  • Posts: 430

Re: Run UpdateDatabase Manually

sibprogsistem wrote:
frmStart.SQLConnection.Connected := False;

Thank you. This one helps.

brian
  • k245
  • k245
  • Member
  • Offline
  • From: Deep
  • Registered: 2017-10-12
  • Posts: 1,589

Re: Run UpdateDatabase Manually

brian.zaballa wrote:
sibprogsistem wrote:
frmStart.SQLConnection.Connected := False;

Thank you. This one helps.

Should this command be placed in the "begin end." section? According to my observations, connecting to SQLite occurs immediately after creating all the forms before opening the main form.

Визуальное программирование: блог и телеграм-канал.

k245's Website

  • From: Philippines
  • Registered: 2018-10-23
  • Posts: 430

Re: Run UpdateDatabase Manually

k245 wrote:
brian.zaballa wrote:
sibprogsistem wrote:
frmStart.SQLConnection.Connected := False;

Thank you. This one helps.

Should this command be placed in the "begin end." section? According to my observations, connecting to SQLite occurs immediately after creating all the forms before opening the main form.

Yes. Thank you for pointing it out. Tried it again and I think UpdateDatabase('') still runs in background even placing the code in the begin end. section

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

Re: Run UpdateDatabase Manually

frmStart.SQLConnection.Connected := False; 
отключает базу данных
но при первой попытке обращения программы к базе данных соединение восстанавливается

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

Re: Run UpdateDatabase Manually

sibprogsistem wrote:

frmStart.SQLConnection.Connected := False; 
отключает базу данных
но при первой попытке обращения программы к базе данных соединение восстанавливается


Do you have a sample sir...
Thank YOu!