Dear List:
It is possible to embed SQL code as a string to be evaluated in R. I am
interested in formatting the SQL code in its own source code block, with
its own syntax highlighting and editing mode (C-c ').
The first time I run the code, I am prompted for R starting directory,
but I get an error:
---
load ESSR: + + + Error: unexpected string constant in:
source('~/.emacs.d/elpa/ess-20140913.1153/etc/ESSR/R/.load.R',
local=TRUE) #define load.ESSR
load.ESSR('"
---
and the console locks. I can C-g to get out of it, and then
re-evaluate, and the code prints what I expect -- the text of the SQL
command.
Is this the right way to go about this? Have I discovered a bug, or
perhaps accidentally a wrong way to get the right answer?
Is this an ESS problem, and not an orgmode problem, per se? My ESS
normally starts up fine, so I thought I would ask on this list first.
A minimal example (first failing, second evaluation giving expected
output) follows.
Best regards,
Eric
Debian GNU/Linux (jessie)
Emacs 24.3.93
Org current from org repo
ESS from MELPA (ca. 14.09)
R 3.1.1 compiled from source
----- SESSION -----
#+TITLE: Test SQL Code
#+AUTHOR: Eric Brown
#+EMAIL: [email protected]
#+PROPERTY: session *R*
#+PROPERTY: cache no
#+name: sqlsource
#+begin_src sql :engine postgresql :eval yes :noweb-ref sqlsrc :exports code
:results none
select
*
from
t
limit
10
#+end_src
#+name: rsource
#+begin_src R :noweb yes :results output :exports both
input <- '
<<sqlsrc>>
'
cat(input)
# dbGetQuery(connectionHandle, input)
#+end_src
#+RESULTS: rsource
:
: select
: *
: from
: t
: limit
: 10
---------------------
