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
_______________________________________________
Help-gnu-emacs mailing list
Help-gnu-emacs@gnu.org
http://lists.gnu.org/mailman/listinfo/help-gnu-emacs
