Re: [sqlite] shell edit quoting

> Where do the quotes around the value come from? I typed them. Simgle set of double quotes > Are you using the standard command-line shell, and which output mode? yes and the default mode ___ sqlite-users mailing list

[sqlite] Feature requests for virtual table mechanism of SQLite

I have some proposals for feature requests for virtual table mechanism of SQLite. Some of this can be useful when accessing remote data over the internet or whatever. Here is the list: * A new method "xInterrupt", called when sqlite3_interrupt() is called. This can be used to cancel

[sqlite] shell edit quoting.

sqlite> insert into sql_procs (name, sql) values ('a', edit('sql','vim')); then in the editor I enter one line: select * from "mytable" ; sqlite> select sql from sql_procs where name = 'a'; sql "select * from ""mytable""; " edit() seems to give 2 quotes for each one entered in the editor.

Re: [sqlite] shell edit quoting

> sqlite> select sql from sql_procs where name = 'a'; > sql > "select * from ""mytable""; > " Where do the quotes around the value come from? Are you using the standard command-line shell, and which output mode? Regards, Clemens ___ sqlite-users

Re: [sqlite] This list is getting spammed again 172

We actually had a go at this. But perhaps it's worth another shot. Dan.

[sqlite] shell edit quoting

sqlite> insert into sql_procs (name, sql) values ('a', edit('sql','vim')); then in the editor I enter one line: select * from "mytable" ; sqlite> select sql from sql_procs where name = 'a'; sql "select * from ""mytable""; " edit() seems to give 2 quotes for each one entered in the editor.