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: Sql-Mode - getting query results from MS SQL Server 2000 Date: Thu, 16 Jun 2005 12:15:57 -0600 Message-ID: References: <20050615192935.GC14624@inkedmn.com> NNTP-Posting-Host: main.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: sea.gmane.org 1118945864 8712 80.91.229.2 (16 Jun 2005 18:17:44 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Thu, 16 Jun 2005 18:17:44 +0000 (UTC) Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Thu Jun 16 20:17:42 2005 Return-path: Original-Received: from lists.gnu.org ([199.232.76.165]) by ciao.gmane.org with esmtp (Exim 4.43) id 1Diyve-0004u3-RU for geh-help-gnu-emacs@m.gmane.org; Thu, 16 Jun 2005 20:17:27 +0200 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Diz17-0004pE-7I for geh-help-gnu-emacs@m.gmane.org; Thu, 16 Jun 2005 14:23:05 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1Diyz4-0004Af-4u for help-gnu-emacs@gnu.org; Thu, 16 Jun 2005 14:20:58 -0400 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1Diyyt-00044y-Ek for help-gnu-emacs@gnu.org; Thu, 16 Jun 2005 14:20:49 -0400 Original-Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Diyys-00042u-T7 for help-gnu-emacs@gnu.org; Thu, 16 Jun 2005 14:20:46 -0400 Original-Received: from [80.91.229.2] (helo=ciao.gmane.org) by monty-python.gnu.org with esmtp (TLS-1.0:RSA_AES_128_CBC_SHA:16) (Exim 4.34) id 1DiyxS-0004nl-1g for help-gnu-emacs@gnu.org; Thu, 16 Jun 2005 14:19:18 -0400 Original-Received: from list by ciao.gmane.org with local (Exim 4.43) id 1Diypz-00040l-4O for help-gnu-emacs@gnu.org; Thu, 16 Jun 2005 20:11:35 +0200 Original-Received: from 207.167.42.60 ([207.167.42.60]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 16 Jun 2005 20:11:35 +0200 Original-Received: from ihs_4664 by 207.167.42.60 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 16 Jun 2005 20:11:35 +0200 X-Injected-Via-Gmane: http://gmane.org/ Original-To: help-gnu-emacs@gnu.org Original-Lines: 39 Original-X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: 207.167.42.60 User-Agent: Mozilla Thunderbird 0.9 (X11/20041105) X-Accept-Language: en-us, en In-Reply-To: <20050615192935.GC14624@inkedmn.com> 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:27506 X-Report-Spam: http://spam.gmane.org/gmane.emacs.help:27506 Brett Kelly wrote: > I'd like to be able to type in a sql query and have it return a resultset in a > different buffer (a la Query Analyzer). Here's what I'm doing now: > - Create a new buffer, do M-x sql-ms RET, then enter the relevant connection > information (user, password, server, dbname). This gives me no errors. > - Type in my SQL statement (I've tried simple "select" statements, as well as > more complicated "create proc" type stuff) > - Highlight the relevant code with the mouse, and choose Send Region from the > SQL menu. > > Now, if I'm understanding this correctly, I should see the results in a new > buffer, but I'm not. From the commentary at the top of sql.el excerpted below, I guess that you are typing your SQL statement directly into the sql-interactive-mode *SQL* buffer. If you enter them in some other sql-mode buffer, Send Region should cause the *SQL* buffer with the results to be displayed (see sql-pop-to-buffer-after-send-region). ;; This file provides a sql-mode and a sql-interactive-mode. The ;; interactive mode had to provide a command-line history; the other ;; mode had to provide "send region/buffer to SQL interpreter" ;; functions. ;; sql-interactive-mode is used to interact with a SQL interpreter ;; process in a SQLi buffer (usually called `*SQL*'). The SQLi buffer ;; is created by calling a SQL interpreter-specific entry function. Do ;; *not* call sql-interactive-mode by itself. ;; sql-mode can be used to keep editing SQL statements. The SQL ;; statements can be sent to the SQL process in the SQLi buffer. -- Kevin Rodgers