OK! It works now. Thank you, Chris. -----Original Message----- From: Programming [mailto:[email protected]] On Behalf Of chris burke Sent: Wednesday, March 8, 2017 21:04 To: Programming forum <[email protected]> Subject: Re: [Jprogramming] FW: sqlite addon
> and also, has a space in the path name. Of course, the library name needs to be quoted. This should be fixed now. Please update the addon and try again, thanks. On Wed, Mar 8, 2017 at 6:44 PM, Tom Arneson <[email protected]> wrote: > > > > > From: Tom Arneson [mailto:[email protected]] > Sent: Wednesday, March 8, 2017 20:41 > To: 'chris burke' <[email protected]> > Subject: RE: [Jprogramming] sqlite addon > > > > The lib matches. > > > > The problem may be due to that on my machine the ~install folder is a > protected folder: > > jpath '~install' > > c:/program files/j64-805 > > and also, has a space in the path name. > > > > In order to run pacman, I have to open as an administrator > > > > dir '~addons/data/sqlite/lib' > > libjsqlite3.dll 3282303 08-Mar-17 20:13:55 > > readme.txt 49 26-Feb-17 10:08:10 > > > > > > From: [email protected] <mailto:[email protected]> [mailto: > [email protected]] On Behalf Of chris burke > Sent: Wednesday, March 8, 2017 20:06 > To: tom arneson <[email protected] <mailto:[email protected]> > > Subject: Fwd: [Jprogramming] sqlite addon > > > > Thanks. I am quite baffled by this. Could you confirm that your binary is: > > > > dir '~addons/data/sqlite/lib' > > libjsqlite3.dll 3282303 08-Mar-17 17:54:58 > > readme.txt 49 26-Feb-17 08:08:10 YES > > > > and that the failing function is: > > > > sqlite3_open_v2_psqlite_ > > 'c:/users/chris/j8/addons/data/sqlite/lib/libjsqlite3.dll > sqlite3_open_v2 > > + i *c *x i *c'&cd > > > > > > ---------- Forwarded message ---------- > > From: Tom Arneson <[email protected] <mailto:[email protected]> > > Date: Wed, Mar 8, 2017 at 5:27 PM > Subject: Re: [Jprogramming] sqlite addon > To: [email protected] <mailto:[email protected]> > > > Chris, > > My answers are inserted in your questions below: > > -----Original Message----- > From: Programming [mailto:[email protected] > <mailto:[email protected]> ] On Behalf Of chris > burke > Sent: Wednesday, March 8, 2017 17:20 > To: Programming forum <[email protected] <mailto: > [email protected]> > > Subject: Re: [Jprogramming] sqlite addon > > I cannot duplicate this, and it works for me on Win10. Can you > experiment a bit and give more info? > > What is your J version? > > JVERSION > Engine: j805/j64/windows > Release: commercial/2016-12-11T08:02:16 > Library: 8.05.14 > Qt IDE: 1.5.3s/5.6.2 > Platform: Win 64 > Installer: J805 install > InstallPath: c:/program files/j64-805 > Contact: www.jsoftware.com <http://www.jsoftware.com> > > What is cder'' after the error? > > db=: sqlopen_psqlite_ '~addons/data/sqlite/db/sandp.db' > |domain error: cd > | SQLITE_OK~: sqlite3_open_v2 file;handle;flags;<<0 > cder'' > 5 0 > > > Do you get the error after restarting J? YES > > > > On Wed, Mar 8, 2017 at 2:04 PM, Tom Arneson <[email protected] <mailto: > [email protected]> > wrote: > > > I tried the sqlite addon with the following results: > > > > > > > > NB. PC running Windows10 > > > > load'data/sqlite' > > > > getbin_psqlite_'' > > > > getbin_psqlite_'' > > > > Sqlite binary installed. > > > > db=: sqlopen_psqlite_ '~addons/data/sqlite/db/sandp.db' > > > > |domain error: cd > > > > | SQLITE_OK~: sqlite3_open_v2 file;handle;flags;<<0 > > > > > > > > NB. Android devices: > > > > getbin_psqlite_'' > > > > Connection failed: Unexpected error > > > > -------------------------------------------------------------------- > > -- 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 > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
