SQLite lister plugin

Discuss and announce Total Commander plugins, addons and other useful tools here, both their usage and their development.

Moderators: Stefan2, white, sheep, Hacker

samoht
Junior Member
Junior Member
Posts: 19
Joined: 2003-02-05, 13:19 UTC

@ lev

Post by *samoht » 2009-02-17, 19:27 UTC

Fehler
Diese Datei ist weder einem Premiumaccount, noch einem Collector's Account zugeordnet und kann deshalb insgesamt nur 10 mal heruntergeladen werden.

Dieses Limit ist erreicht.

Um diese Datei herunterladen zu können, muss der Anbieter entweder die Datei in seinen Collector's Account verschieben, oder die Datei erneut raufladen. Die Datei kann nachträglich in ein Collector's Account verschoben werden. Der Anbieter muss nur auf den Löschlink der Datei klicken, um mehr Informationen zu erhalten.

User avatar
fenix_productions
Power Member
Power Member
Posts: 1952
Joined: 2005-08-07, 13:23 UTC
Location: Poland
Contact:

Post by *fenix_productions » 2009-02-18, 09:11 UTC

2Lev
Anytime I try to load db file I've got a message:

Code: Select all

---------------------------
Error
---------------------------
Unable to open this table! Locked?
---------------------------
OK   
---------------------------
After that, there is 50% chance that file will be displayed in lister.

Column's sizes are not remembered. They should be: either separately for each table (and DB file) or globally. Autosize feature could be great too.
"When we created the poke, we thought it would be cool to have a feature without any specific purpose." Facebook...

#128099

User avatar
Lev
Junior Member
Junior Member
Posts: 82
Joined: 2004-12-14, 13:08 UTC

Post by *Lev » 2009-02-18, 14:44 UTC

fenix productions Sorry, several posts before I said that I'm not the author of a plugin, I just compiled it.
samoht Didn't thought that there will be more then 10 men wanting to get this plugin. Reloaded to sendspace, hope it will work better.

User avatar
fenix_productions
Power Member
Power Member
Posts: 1952
Joined: 2005-08-07, 13:23 UTC
Location: Poland
Contact:

Post by *fenix_productions » 2009-02-18, 15:08 UTC

2Lev
OK. I just assumed that you've changed your mind after reading about fixing detection string or embedding DLL :)
"When we created the poke, we thought it would be cool to have a feature without any specific purpose." Facebook...

#128099

User avatar
nsp
Power Member
Power Member
Posts: 1194
Joined: 2005-12-04, 08:39 UTC
Location: Lyon (FRANCE)
Contact:

Post by *nsp » 2009-09-09, 12:23 UTC

Lev wrote:The new version of the same plugin - http://rapidshare.com/files/199194020/wLx_SQLLite.rar.html.
Compiled with sqlite3.dll embedded in it, no need to have it in the PATH, but the size of a plugin became larger.
Supports passing of 1-7, Esc, etc.
Better work in QuickView mode (Ctrl+Q)
I don't remember whether I corrected the detect string in the plugin itself, if plugin reacts on thumbs.db etc., set the detect string to - "EXT="DB" & [0]="S" & [1]="Q" & [2]="L""
Hi,

I've tested the plugin but it seems that output is not updated if the result is empty !

Select should also be quoted i.e select * from "TableName" in order to support Name with special character like % \ ..

it could also be fine to have a query popup to avoid touble with "2" "3" "4" key in lister mode.

besieger
Junior Member
Junior Member
Posts: 8
Joined: 2009-04-27, 06:37 UTC

Post by *besieger » 2009-11-28, 16:26 UTC

Lev wrote:samoht Didn't thought that there will be more then 10 men wanting to get this plugin. Reloaded to sendspace, hope it will work better.

Sorry, the file you requested is not available.

Could you please re-upload, maybe to megaupload since i need that plugin as well.

User avatar
fenix_productions
Power Member
Power Member
Posts: 1952
Joined: 2005-08-07, 13:23 UTC
Location: Poland
Contact:

Post by *fenix_productions » 2009-11-28, 18:34 UTC

"When we created the poke, we thought it would be cool to have a feature without any specific purpose." Facebook...

#128099

MK2k
Junior Member
Junior Member
Posts: 3
Joined: 2008-06-25, 10:41 UTC

Post by *MK2k » 2012-12-25, 12:43 UTC

is there a chance for a 64bit version of the plugin that fenix_productions posted?

User avatar
SkipR
Junior Member
Junior Member
Posts: 48
Joined: 2008-03-27, 10:39 UTC
Location: W. Australia

Another viewer

Post by *SkipR » 2014-05-30, 18:29 UTC

Read this old thread as I was looking for a SQLite viewer

I went with http://www.totalcmd.net/plugring/sqliteviewer.html and tested ok. I changed the detect string to check any file extension for "SQL" ([0]="S" & [1]="Q" & [2]="L") in first 3 bytes as I have some software that uses a non-standard file extensions.

Code: Select all

7=%COMMANDER_PATH%\plugins\wlx\SQLiteViewer\SQLiteViewer.wlx
7_detect="MULTIMEDIA & ext="DB" | ext="DB3" | ext="SQLITE" | ext="SQLITE3" | ext="FOSSIL" | [0]="S" & [1]="Q" & [2]="L""
Skip
Perth, AU

User avatar
nn1k3
Member
Member
Posts: 116
Joined: 2007-02-06, 16:59 UTC

Re: Another viewer

Post by *nn1k3 » 2017-12-15, 23:44 UTC

SkipR wrote:Read this old thread as I was looking for a SQLite viewer
I went with http://www.totalcmd.net/plugring/sqliteviewer.html and tested ok.
Thanks - now I can see the data. I can also copy one row to clipboard.
QUESTION: How can I copy all the rows to clipboard? (I can only select one row)

Post Reply