-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gilles Ganault Sent: Friday, October 23, 2009 11:12 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?
On Fri, 23 Oct 2009 10:19:17 -0400, "Griggs, Donald" <donald.gri...@allscripts.com> wrote: >I'm grateful to Mike Cariotoglou for Sqlite3Explorer > http://www.singular.gr/sqlite/ Unless I overlooked it, it won't let me copy all the rows into the clipboard (tried CTRL-A, also tried selecting the first and the last row followed by CTRL-C, to no avail). Also... "V3.01 29/11/2007" "Access violation at address 006C304F in module 'sqlite3Explorer.exe'. Read of address 00000039." Too bad :-/ Thanks anyway. ===================================== Regarding Sqlite3Explorer: "..it won't let me copy all the rows into the clipboard ..." I should probably have mentioned that RIGHT-CLICK within the output grid provides an option to "COPY RESULT SET TO CLIPBOARD". I just tried it with 9150 rows, and they appeared to paste correctly into a blank Micro$oft Excel spreadsheet. For truly *huge* outputs, you may prefer a script to export from sqlite3.exe and import elsewhere. Regarding: "Access violation ...." I cant' say. I think the author may be on this list, or you can search out his email address. Hope this helps, Donald _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users