-
May 21st, 2018, 04:33 AM
#1
Thread Starter
Fanatic Member
How do I get the latest version of SQLite?
A couple of years ago, I got vbRichClient5.dll (that manages SQLite for VB6) from the following link:
http://www.vbrichclient.com/#/en/About/
Ever since then, this dll has not changed.
However, I know that SQLite has released many new updates since then. Currently it is version 3.23
But, when I run this query:
Code:
select sqlite_version()
on my SQLite database (which is managed by vbRichClient5.dll, it returns version 3.8.11.1
So, how do I get the latest version of SQLite?
Please advise.
Thanks.
-
May 21st, 2018, 04:42 AM
#2
Re: How do I get the latest version of SQLite?
Originally Posted by IliaPreston
You cannot download RC5 from it's about page, better try from it's download page at http://www.vbrichclient.com/#/en/Downloads.htm
On the download page it says "current version: 5.0.66, last update: 2018-02-04" -- this is more recent that couple of year ago.
Note, vbRichClient5.dll is not going to auto-update -- you have to manually download the .zip, extract, register and subsequently distribute the required dlls with your solution.
Also note, that cConnection class has Version property (actually a function) that basicly does what your query is returning.
cheers,
</wqw>
-
May 21st, 2018, 10:46 AM
#3
Re: How do I get the latest version of SQLite?
Originally Posted by wqweto
"current version: 5.0.66, last update: 2018-02-04" -- this is more recent that couple of year ago.
Yep...
@IliaPreston
...also note that not only vbRichClient5.dll (a COM-binary containing the wrapper-classes) is available in newer versions,
but also that the "flat" vb_cairo_sqlite.dll (which the sqlite-sources are compiled into) is usually updated along with it -
(currently at SQLite version 3.21, which is only two months or so behind the recent SQLite-version 3.23.1 -
...I read along in the SQLite-mailinglist and timeline-change-logs, and often skip one or two versions, depending on
"how much new stuff" was introduced into the SQLite-sources, and how fast the "dust settles" for that after introducion).
For example, new in 3.22 was a new "virtual-table for ZIP-files" - and in 3.23 there were a few "corner-case-fixes"
for that Zip-Table-feature (my plan is, to make a new release, as soon as 3.24 comes out - including that Zip-Table-feature).
Olaf
Last edited by Schmidt; May 21st, 2018 at 10:49 AM.
-
May 29th, 2018, 05:33 PM
#4
Re: How do I get the latest version of SQLite?
Originally Posted by Schmidt
(my plan is, to make a new release, as soon as 3.24 comes out - including that Zip-Table-feature).
Hi Olaf, regarding that new release, I just posted a small wishlist to our good ole' newsgroup, see https://groups.google.com/forum/#!to...ic/3SCZNrVKEdY
Sorry folks, that's in German - but actually most of it is in VB6 so it's international. ;-)
Cheers Wolfgang
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|