Re: LuaSQL and PRAGMAs

[Marc Balmer <marc@...>]

Am 12.02.2013 um 08:00 schrieb Vadim Peretokin <vperetokin@gmail.com>:

> Has anyone had luck with PRAGMAs using a recent sqlite and LuaSQL version? Retrieving results seems to be broken:
> 
> Lua 5.1.4 Copyright (C) 1994-2008 Lua.org, PUC-Rio
> > require"luasql.sqlite3"
> > env = luasql.sqlite3()
> > env:connect("/home/vadi/Desktop/test")
> > conn = env:connect("/home/vadi/Desktop/test")
> > =type(conn)
> userdata
> > =conn
> SQLite3 connection (0xc0bc58)
> > cur = conn:execute("PRAGMA table_info('people')")
> > =cur
> SQLite3 cursor (0xc10218)
> > row = cur:fetch({}, "a")
> > =row
> nil
> > 
> 
> There's been a similar post on Kepler (http://lists.luaforge.net/pipermail/kepler-project/2010-September/004338.html), not much of a conclusion out of that except that LuaSQL is starting to become outdated...


Have you tried if the Lua SQLite3 binding at https://github.com/mbalmer/luasqlite has the same problem?  Maybe that one works (I did not test it myself yet).