Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?
On 2018-10-19, at 09:02, Winfried wrote: > Before I build a GUI, is there a Windows SQLite database manager that can do > this? > > I tried DB Browser for SQLite, SQLitespeed, and SQLiteStudio, but none seems > to support this feature. SQLite's closest thing to a native scripting language is Tcl, with a Tk graphical toolkit. If you write your app in Tcl/Tk it will run on Windows, Mac, and UNIX. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?
Am 19.10.2018 um 16:02 schrieb Winfried:
I have a bunch of hyperlinks in an SQLite database, and need to read
each page for validation before deleting the record.
To make it easier, the DB manager should launch the default web browser
when I double click on a column that contains a hyperlink.
Before I build a GUI, is there a Windows SQLite database manager
that can do this?
Am a bit late here - but perhaps it's interesting for others as well...
Since you need it for Windows - why not write a little tool for that -
using VBScript (*.vbs Files), which are supported on all current Win-OS.
VBScript interacts nicely with COM-libraries (less so with "flat-Dlls"),
via CreateObject("Lib.Class") - so your question basically boils down to:
- is there a COM-lib for SQLite
- is there a COM-lib which also supports GUI-development
- does this GUI-support include DataGrid-Bindings to SQLite-ResultSets
(to keep the efforts low)...
Well, yes there is: http://vbRichClient.com/#/en/Downloads.htm
(a COM-framework, which wraps SQLite - as well as cairo for its GUI-
and drawing-stuff).
Whilst the above Link is targetting VBA and VB6-developers primarily,
an adaption with decent support for VBScript-development is here:
http://vbRichClient.com/Downloads/ScriptGUI5.zip
The above Zip contains several *.vbs examples in its Root-Folder -
and already includes all the needed libs in a \Bin\-SubDirectory.
The tool allows after unzipping, a development "right-out-of-the-box"
(it does not require any Setup when running on Win-Systems > XP) -
and the frameworks size is comparably small (about 3MB zipped).
I've included a solution to your problem already in two versions:
(both demos are using a dynamically created "Urls"-DB and -Table)
- SQLite_DataGrid_Simple.vbs
- SQLite_DataGrid.vbs
Here is a ScreenShot of the complete Code for the simple version:
http://vbRichClient.com/Downloads/ScriptGUI5.png
And here one of the running *.vbs-App from the "enhanced version"
(which has only a dozen more lines of code than the simple one):
http://vbRichClient.com/Downloads/SQLiteDataGrid.png
Help-Files which describe the interfaces of the Framework-
Classes are contained as *.chm in the Zips \Doc\ Subdirectory.
HTH
Olaf
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
