My Visual Database — Run UpdateDatabase Manually

Re: Run UpdateDatabase Manually

null@example.com (manixs2013) — Fri, 06 Aug 2021 02:08:14 +0000

sibprogsistem wrote:

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

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

Re: Run UpdateDatabase Manually

null@example.com (sibprogsistem) — Wed, 04 Aug 2021 11:54:23 +0000

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

Re: Run UpdateDatabase Manually

null@example.com (brian.zaballa) — Wed, 04 Aug 2021 09:17:29 +0000

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

Re: Run UpdateDatabase Manually

null@example.com (k245) — Wed, 04 Aug 2021 07:41:48 +0000

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.

Re: Run UpdateDatabase Manually

null@example.com (brian.zaballa) — Tue, 03 Aug 2021 13:51:14 +0000

sibprogsistem wrote:

frmStart.SQLConnection.Connected := False;

Thank you. This one helps.

Re: Run UpdateDatabase Manually

null@example.com (sibprogsistem) — Tue, 03 Aug 2021 11:30:30 +0000

frmStart.SQLConnection.Connected := False;

Re: Run UpdateDatabase Manually

null@example.com (brian.zaballa) — Tue, 03 Aug 2021 05:39:58 +0000

Run UpdateDatabase Manually

null@example.com (brian.zaballa) — Sat, 08 Aug 2020 05:35:53 +0000

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.