[sqlite] how to submit a file with sql to sqlite

dear listers, i am wondering if there is a way to submit a file with many sql statements, say several hundred lines, to sqlite. thanks for your insight. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] how to submit a file with sql to sqlite

very cool! Thanks, Gabor. On Sun, Apr 18, 2010 at 12:16 PM, Gabor Grothendieck ggrothendi...@gmail.com wrote: On Sun, Apr 18, 2010 at 12:02 PM, Wensui Liu liuwen...@gmail.com wrote: dear listers, i am wondering if there is a way to submit a file with many sql statements, say several hundred

Re: [sqlite] mode is not changed

wonderful question, it is also what i'd like to know. On Thu, Dec 31, 2009 at 1:03 PM, Simon Slavin slav...@bigfraud.org wrote: On 31 Dec 2009, at 4:56pm, Kees Nuyt wrote: On Thu, 31 Dec 2009 04:24:51 +, Simon Slavin slav...@bigfraud.org wrote: On 31 Dec 2009, at 2:13am, Wensui Liu

[sqlite] mode is not changed

dear listers, i am trying to change the output by 'sqlite3 mydb .mode csv'. however, when i type 'sqlite3 mydb .show', I couldn't see the change of mode at all. i appreciate it if anyone can point me to a right direction. thanks and happy new year! wensui

[sqlite] sqlite with emacs (OT)

good morning, all, when i tried to use sqlite in emacs with shell mode, it doesn't work. is there a interface for sqlite in emacs / xemacs? thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite with emacs (OT)

PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derrell Lipman Sent: Wednesday, April 02, 2008 9:36 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] sqlite with emacs (OT) On Wed, Apr 2, 2008 at 10:30 AM, Wensui Liu [EMAIL PROTECTED] wrote: good morning, all

[sqlite] Does ODBC of sqlite support delete function?

Dear Lister, I use SAS, a statistical computing language, to link to a sqlite database through ODBC. When I tried to delete rows from a table, it says the delete function is not supported. Does ODBC support delete function? Thanks.