Oh,Marc, thank you. This did the trick: [ch=. ddcon__db 'database=',(jpath'~/j803/testdb')
I should read the wiki more carefully. Thanks again, Jon > From: [email protected] > Date: Sat, 22 Nov 2014 19:25:29 +0530 > To: [email protected] > Subject: Re: [Jprogramming] Sqlite addon with J802/3 > > Hi Jon, > > Your connection string is wrong; please see > > http://jsoftware.com/jwiki/JDD/Methods/Connect > > Working example: > > require'data/ddsqlite' > db=: ''conew'jddsqlite' > ddcon__db'database=',(jpath'~temp/test.db'),';nocreate=0' > 4349166272 > > If you only want to access existing databases, you can drop the > nocreate parameter. > > Best, > Marc > > On Sat, Nov 22, 2014 at 6:26 PM, bill lam <[email protected]> wrote: > > try add jpath to supply a real file path. > > On Nov 22, 2014 4:50 PM, "Jon Hough" <[email protected]> wrote: > > > >> I am attempting to use the Sqlite addon (ddsqlite) with J and am > >> struggling to get a db connection. > >> Environment:Linux Ubuntu 14.x, J802/3Sqlite 3 > >> > >> My code so far is: > >> > >> load 'data/ddsqlite' > >> > >> > >> > >> > >> db =: '' conew 'jddsqlite' > >> > >> > >> > >> > >> [ch=. ddcon__db '~/j803/testdb' > >> > >> > >> this returns -1. It seems it cannot find my sqlite database, testdb. > >> > >> > >> Of course, the obvious question is 'did I put my database in the correct > >> place?'. > >> > >> > >> The answer is yes, as doing > >> > >> > >> > >> > >> ]d =: fread <'~/j803/db' > >> > >> > >> doesn't fail. > >> > >> > >> Any help appreciated. > >> Thanks, > >> > >> > >> Jon > >> > >> ---------------------------------------------------------------------- > >> For information about J forums see http://www.jsoftware.com/forums.htm > >> > > ---------------------------------------------------------------------- > > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
