SQLite in 7.01h?

SQLite in 7.01h?

[Bill Harris]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm probably just missing it, but I didn't see anything in the manual,
the FAQ, the mailing list, or from a Google search.

I rediscovered org-mode this week; I had used much earlier versions some
years ago, but org-babel really attracted my attention.  

I've gotten v 7.01h to work on Debian Stable and XP for R, elisp, and
sh, but I can't figure out how to make it work for SQLite.  I did enable
SQLite as one of the languages, but, when I execute the following
section, I get "No org-babel-execute function for Sqlite!":

#+BEGIN_SRC Sqlite 
  sqlite3 sqlite/db.sqlite
  select * from table;
#+END_SRC

(The org-mode file is in a directory with a subdirectory called sqlite,
and the database is there.)

I did a similar thing for R, and it works:

#+BEGIN_SRC R
	  3 + 4
#+END_SRC

#+results:
: 7

I'm running this test with GNU Emacs 22.2.1 on Debian Stable; I'm
running sqlite3 version 3.5.9.

What am I missing?  Can you give me an example SQLite source code block
that works?

Thanks,

Bill
- -- 
Bill Harris                  http://makingsense.facilitatedsystems.com/
Facilitated Systems                              Everett, WA 98208 USA
http://www.facilitatedsystems.com/               phone: +1 425 374-1845
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkyVBacACgkQ3J3HaQTDvd8avQCfVQ4gMOXMjEHRqrETLJG+pmrt
OW4AnR1Kbh7wHEV+qZuSJOfeKGUCSMv+
=DPVV
-----END PGP SIGNATURE-----

Re: SQLite in 7.01h?

[Bill Harris]

Bill Harris <bill_harris@facilitatedsystems.com> writes:

> I've gotten v 7.01h to work on Debian Stable and XP for R, elisp, and
> sh, but I can't figure out how to make it work for SQLite.  I did enable
> SQLite as one of the languages, but, when I execute the following
> section, I get "No org-babel-execute function for Sqlite!":
>
> #+BEGIN_SRC Sqlite 
>   sqlite3 sqlite/db.sqlite
>   select * from table;
> #+END_SRC

I found a workaround

#+begin_src sh :results replace
  sqlite3 sqlite/db.sqlite 'select * from table;'
#+end_src

but it would surely be nice to be able to use the SQLite connection
directly.

Bill
-- 
Bill Harris                  http://makingsense.facilitatedsystems.com/
Facilitated Systems                              Everett, WA 98208 USA
http://www.facilitatedsystems.com/               phone: +1 425 374-1845

Re: SQLite in 7.01h?

[Michael Gauland]

I believe all you need to do is change 'Sqlite' to 'sqlite' (all lower case) in
the +BEGIN_SRC line.

--Mike