From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Kevin Rodgers Newsgroups: gmane.emacs.help Subject: Re: comint or start-process Date: Thu, 10 Dec 2009 20:58:31 -0700 Message-ID: References: <200912092329.nB9NTfJn013100@fed.local> <200912101200.nBAC0dWn001131@fed.local> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: ger.gmane.org 1260503980 27311 80.91.229.12 (11 Dec 2009 03:59:40 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Fri, 11 Dec 2009 03:59:40 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Fri Dec 11 04:59:33 2009 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1NIwfE-0004nl-JW for geh-help-gnu-emacs@m.gmane.org; Fri, 11 Dec 2009 04:59:32 +0100 Original-Received: from localhost ([127.0.0.1]:47771 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NIwfE-0002rC-PX for geh-help-gnu-emacs@m.gmane.org; Thu, 10 Dec 2009 22:59:32 -0500 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NIweo-0002pq-OU for help-gnu-emacs@gnu.org; Thu, 10 Dec 2009 22:59:06 -0500 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1NIwek-0002o9-W3 for help-gnu-emacs@gnu.org; Thu, 10 Dec 2009 22:59:06 -0500 Original-Received: from [199.232.76.173] (port=36629 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NIwek-0002o2-M9 for help-gnu-emacs@gnu.org; Thu, 10 Dec 2009 22:59:02 -0500 Original-Received: from lo.gmane.org ([80.91.229.12]:34477) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1NIwej-000270-QJ for help-gnu-emacs@gnu.org; Thu, 10 Dec 2009 22:59:02 -0500 Original-Received: from list by lo.gmane.org with local (Exim 4.50) id 1NIweh-0004e6-J5 for help-gnu-emacs@gnu.org; Fri, 11 Dec 2009 04:58:59 +0100 Original-Received: from c-71-237-24-138.hsd1.co.comcast.net ([71.237.24.138]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 11 Dec 2009 04:58:59 +0100 Original-Received: from kevin.d.rodgers by c-71-237-24-138.hsd1.co.comcast.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 11 Dec 2009 04:58:59 +0100 X-Injected-Via-Gmane: http://gmane.org/ Original-Lines: 37 Original-X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: c-71-237-24-138.hsd1.co.comcast.net User-Agent: Thunderbird 2.0.0.23 (Macintosh/20090812) In-Reply-To: <200912101200.nBAC0dWn001131@fed.local> X-detected-operating-system: by monty-python.gnu.org: GNU/Linux 2.6 (newer, 3) X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:70581 Archived-At: Xavier Maillard wrote: > Ok. I have tried to get something but failed: > > (defun sqlite-connect (db) > (let ((sql-database db)) > (sql-connect-sqlite))) > > (sqlite-connect "/tmp/foo.db") > (with-current-buffer (process-buffer (get-process "SQL"))) > (sql-send-string "select * from foo;")) > > => > > No SQL process started. > > M-x list-process: > > Proc Status Buffer Tty Command > ---- ------ ------ --- ------- > SQL run *SQL* /dev/pts/2 sqlite /tmp/foot.db > > What is the problem ? Use the source: "No SQL process started" is reported by sql-send-string when (buffer-live-p sql-buffer) returns nil. Usually, sql-buffer is set by sql-product-interactive, which you have circumvented by calling sql-connect-sqlite directly. Perhaps all you need to do is: (let ((sql-buffer (process-buffer (get-process "SQL")))) (with-current-buffer sql-buffer (sql-send-string "select * from foo;"))) -- Kevin Rodgers Denver, Colorado, USA