• Registered: 2017-02-01
  • Posts: 106

Topic: Folder with sqlite3.dll

Hello to all.


the included sqlite3.dll from MyVisualDatabase is from 2014.


In which folder can I place a newer version of this .dll that it will be copied to all compiled projects? After every compilation I get the old version back in the project folder.


An IT Newsletter has written that the newer versions of SQLITE have a speed improvement. More speed is a good thing.

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

Re: Folder with sqlite3.dll

teco049 wrote:

Hello to all.


the included sqlite3.dll from MyVisualDatabase is from 2014.


In which folder can I place a newer version of this .dll that it will be copied to all compiled projects? After every compilation I get the old version back in the project folder.


An IT Newsletter has written that the newer versions of SQLITE have a speed improvement. More speed is a good thing.

You can put it under the installation folder of your MVD. In my case it is under "C:\Program Files (x86)\My Visual DataBase"


just make sure to have a backup of the current sqlite, you might run into an error when accessing 2 level of parent of a child in a report using the new version of sqlite. I hope you dont have this kind of record in your project/application. This error was not been fixed.

Here's my post with regards to the problem
http://myvisualdatabase.com/forum/viewtopic.php?id=7339

brian

3 Reply by sparrow (edited by sparrow 2021-11-10 23:53:45)

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

Re: Folder with sqlite3.dll

Hi brian.zaballa

In one project, I came across such a situation.
The checkbox mark is a dictionary on one of the tables, swapped JOIN in the query that built the MVD.
In your test case with an error (http://myvisualdatabase.com/forum/viewtopic.php?id=7339), specify
the check-dictionary on the "department" table. JOIN changes.
But replacing with a newer version has its advantages. 


The first time I saw the action of a checkbox. )

Post's attachments

Attachment icon join.jpg 30.24 kb, 81 downloads since 2021-11-11 

4 Reply by brian.zaballa (edited by brian.zaballa 2021-11-11 01:13:49)

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

Re: Folder with sqlite3.dll

sparrow wrote:

Hi brian.zaballa

In one project, I came across such a situation.
The checkbox mark is a dictionary on one of the tables, swapped JOIN in the query that built the MVD.
In your test case with an error (http://myvisualdatabase.com/forum/viewtopic.php?id=7339), specify
the check-dictionary on the "department" table. JOIN changes.
But replacing with a newer version has its advantages. 


The first time I saw the action of a checkbox. )

Oh, that solves the problem. Thank you for sharing. Checking Dictionary checkbox for the department solves the error. Kudos!

I'm using the latest(3.36.0) sqlite version on my MVD projects. Looking forward for the succeeding releases. Hoping they include UPDATE query alongside JOIN. smile

brian