Re: SQLite best library to use

["NU-g.lister" <g.lister@...>]

----- Original message -----
>
> On Sep 26, 2012, at 3:21 PM, "g.lister" <g.lister@nodeunit.com> wrote:
>
> > On 09/26/2012 09:19 PM, M. Edward (Ed) Borasky wrote:
> > > Is the file compressed?
> >
> > Not sure if it would be as I created it with sqlite test.db???
>
> Try creating it with
>
>        sqlite3 test.db
>
> e
>

maybe therein lies the problem I don't have sqlite3 but just sqlite...

Would code like this cause an issue:

function openDbConn()
conn = env:open("test.db")
..
end


conn:execute("select ....")

as far as I know conn is still in scope I think it is a version issue. I did recreate the file and sqlite test.db ".dump" gives me what is in it.

Thanks!
George