OK! It works now. Thank you, Chris. -----Original Message----- From: Programming [mailto:programming-boun...@forums.jsoftware.com] On Behalf Of chris burke Sent: Wednesday, March 8, 2017 21:04 To: Programming forum <programm...@jsoftware.com> 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 <t...@tomarneson.com> wrote: > > > > > From: Tom Arneson [mailto:t...@tomarneson.com] > Sent: Wednesday, March 8, 2017 20:41 > To: 'chris burke' <cbu...@jsoftware.com> > 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: cdbu...@gmail.com <mailto:cdbu...@gmail.com> [mailto: > cdbu...@gmail.com] On Behalf Of chris burke > Sent: Wednesday, March 8, 2017 20:06 > To: tom arneson <t...@tomarneson.com <mailto:t...@tomarneson.com> > > 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 <t...@tomarneson.com <mailto:t...@tomarneson.com> > > Date: Wed, Mar 8, 2017 at 5:27 PM > Subject: Re: [Jprogramming] sqlite addon > To: programm...@jsoftware.com <mailto:programm...@jsoftware.com> > > > Chris, > > My answers are inserted in your questions below: > > -----Original Message----- > From: Programming [mailto:programming-boun...@forums.jsoftware.com > <mailto:programming-boun...@forums.jsoftware.com> ] On Behalf Of chris > burke > Sent: Wednesday, March 8, 2017 17:20 > To: Programming forum <programm...@jsoftware.com <mailto: > programm...@jsoftware.com> > > 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 <t...@tomarneson.com <mailto: > t...@tomarneson.com> > 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
