Hi Cecil,
On Fri, 31 Aug 2018 12:24:33 +0200 Cecil Westerhof <cldwester...@gmail.com> wrote: > 2018-08-31 11:17 GMT+02:00 Robert Klein <rokl...@roklein.de>: > > > Hi Cecil, > > > > On Fri, 31 Aug 2018 10:47:50 +0200 > > Cecil Westerhof <cldwester...@gmail.com> wrote: > > > > > I have a strange problem with org-babel and SQLite. > > > > > > I have a database that is created with: > > > CREATE TABLE "quotes" ( > > > quoteID TEXT PRIMARY KEY, > > > quote TEXT NOT NULL UNIQUE, > > > lastUsed TEXT, > > > totalUsed INT DEFAULT 'unused' > > > ) > > > > > > When using: > > > #+BEGIN_SRC sqlite :db ~/Twitter/twitter.sqlite :colnames yes > > > SELECT lastUsed > > > , totalUsed > > > FROM quotes > > > ORDER BY lastused ASC > > > , totalUsed DESC > > > LIMIT 40 > > > #+END_SRC > > > > > > Everything is fine. But when I use (add the quote field in the > > > select): #+BEGIN_SRC sqlite :db > > > ~/Twitter/twitter.sqlite :colnames yes SELECT quote > > > , lastUsed > > > , totalUsed > > > FROM quotes > > > ORDER BY lastused ASC > > > , totalUsed DESC > > > LIMIT 40 > > > #+END_SRC > > > > > > I get: > > > executing Sqlite code block... > > > Wrote /tmp/babel-27920y_/ob-input-2792BTG > > > org-babel-read: End of file during parsing > > > > > > What could be the problem? > > > > > > > does it work outside of org/babel/emacs, that is, when you use the > > query in a command line sqlite session, does it work? “quote” is > > also a function in sqlite, so this might be your issue. > > > > Yes, in sqlite3 and sqlitebrowser it works without problems. > In org-babel even 'SELECT *' goes wrong. > I can't reproduce the issue, it works for me. What are your org-mode and Emacs versions? Can you provide an ECM (Example, complete, minimal) org-mode setup / Emacs initialization file? Best regards Robert