[sqlite] Tcl API docs - clarification

SNAME? ?-readonly BOOLEAN? ?-create BOOLEAN? ?-nomutex BOOLEAN? ?-fullmutex BOOLEAN?" Would it be possible for you to add these options for the 'sqlite3' command to the Tcl API document. Thanks John Gillespie ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] How do you load a ".csv" and skip the first line?

I use "SQLite Manager " extension for Firefox. Don't know if it is available for IE, didn't find it for Safari. John G On 4 September 2012 21:23, Peter Haworth wrote: > Take a look at my SQLiteAdmin tool. It will import csv files with or > without headers, export them that

Re: [sqlite] SQLite Provenance

If you want instant info on the 'provenance' of a website use the Firefox add-on "Flagfox". It gives you a little flag next to the address. John Gillespie On 6 July 2012 22:58, Gavin T Watt <gw...@raytheon.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > H

Re: [sqlite] system.data.sqlite 1.0.81.0 - .edmx creation issue

This works as expected for me. What version are you using? Did you set the pragma each time? What do you mean by ".edmx" John G % sqlite3 test.db SQLite version 3.7.7 2011-06-25 16:35:41 pragma foreign_keys=1; CREATE TABLE Lesson ( id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT NOT

Re: [sqlite] SQLite Tcl Extension

No: here is info from my mac - Mac OSX (run in terminal) : ~ 596 % sqlite3 test.db SQLite version 3.7.7 2011-06-25 16:35:41 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .e ~ 597 % wish % set tcl_version 8.5 % package require sqlite3 3.7.5 % exit As you can

Re: [sqlite] Primary Key uniqueness

Try omitting 'rowid' - you are not grouping by it and if you did it is unique so no dups. select Column_1,Column_27,Column_47 , count(*) from old_table group by Column_1,Column_27,Column_47 having count(*) > 1 JG On 29 March 2012 17:27, Joe Bennett

Re: [sqlite] table names on the fly

Alternatively in tcl : dbcmd eval { create table mytable ( aaa integer, text) } dbcmd eval { insert into mytable (aaa,bbb) values (1, '') } dbcmd eval "select * from mytable" loopvar { # loopvar(*) contains the column names, loopvar(aaa) contains 1, loopvar(bbb) contains

Re: [sqlite] Procedure (Conditional statement) workaround

This would make a good entry for an Obfuscated SQL contest. Well done John On 19 December 2011 21:43, Nico Williams wrote: > You can do conditionals via WHERE clauses, as others have pointed out. > You can also use WHEN clauses on triggers. > > Think of it as IF .

Re: [sqlite] Tcl syntax help

Try set roads {"Miller lane" "Pine street" "Wilson blvd"} set SQL "insert into myTable VALUES( '[join $road "','"]' )" db eval $SQL # note the single quotes on each side of the join command # and the argument to the join command. JG ___ sqlite-users