[sqlite] sqlite with emacs (OT)

2008-04-02 Thread Wensui Liu
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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlit

Re: [sqlite] sqlite with emacs (OT)

2008-04-02 Thread Wensui Liu
-Original Message- > > From: [EMAIL 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) > >

[sqlite] Does ODBC of sqlite support delete function?

2006-08-26 Thread Wensui Liu
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. --

[sqlite] mode is not changed

2009-12-30 Thread Wensui Liu
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

Re: [sqlite] mode is not changed

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

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

2010-04-18 Thread Wensui Liu
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 http://sqlite.org:8080/cgi-bin/mailman/listinf

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

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