This would be something you'd need to write something quick for. There's no application in the world that knows how to use your specific schema and react to it. There may be apps that will read the values and automatically 'understand' that http:// and https:// are addresses, but, these probably are custom built applications that do something completely different to what you're doing. I've just checked with SQLite Expert, and it doesn't have any knowledge of how to treat a field as a URL/URI.
That said, you may be able to get an ugly query going, and dump it to an HTML file you can bring up in your browser. My example table: CREATE TABLE [Test]( [TestID] INTEGER, [Name] CHAR, [Address] URL); INSERT INTO [Test]([TestID], [Name], [Address]) VALUES(1, 'Google', ' http://www.google.com'); INSERT INTO [Test]([TestID], [Name], [Address]) VALUES(2, 'YouTube', ' http://www.youtube.com'); Then execute SQLite3.exe like this: R:\>c:\myapps\sqlite3.exe SQLite version 3.20.0 2017-08-01 13:24:15 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .open TestDB.db3 sqlite> .output test.html sqlite> select '<a href="'||Address||'">'||Name||'</a><br>\n' from Test; sqlite> .quit R:\>type test.html <a href="http://www.google.com";>Google</a><br>\n <a href="http://www.youtube.com";>YouTube</a><br>\n (R: for me is a RamDRIVE) On Fri, Oct 19, 2018 at 10:03 AM Winfried <codecompl...@free.fr> wrote: > Hello, > > 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? > > I tried DB Browser for SQLite, SQLitespeed, and SQLiteStudio, but none > seems > to support this feature. > > Thank you. > > > > -- > Sent from: http://sqlite.1065341.n5.nabble.com/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
