Re: Tabs and ends of lines in sql mode

[Thien-Thi Nguyen]

jiri.pejchal@gmail.com writes:

> Is there a way for sql-send-paragraph to not sends the tabs and ends
> of lines?

it has to send at least one newline (at the end of the paragraph).
you probably meant to say internal tabs and newlines.  the best
solution would be to disable the secondary prompting and
completion in the subproc, but here is a rewrite of
`sql-send-paragraph' as a workaround:

(defun sql-send-paragraph ()
  "Send the current paragraph to the SQL process."
  (interactive)
  (let ((raw (buffer-substring-no-properties
              (save-excursion
                (backward-paragraph)
                (point))
              (save-excursion
                (forward-paragraph)
                (point)))))
    ;; subdue secondary-prompting and completion over-helpfulness
    (while (string-match "\n\t*" raw)
      (setq raw (concat (substring raw 0 (match-beginning 0))
                        " "
                        (substring raw (match-end 0)))))
    (sql-send-string raw)))

i think this is ugly, however.  mulling over comint.el now...

thi