The sqlite library for Yosemite is broken. I stumbled upon it when John (I think) asked about how to use SQLite and I tried it myself. There is a workaround. Use another sqlite library. I use macports to install other linux/GNU software stuff on my mac. If you use the full path of the libsqlite.dylib (instead of the default library unxlib 'sqlite3'... /opt/local/lib/libsqlie3.dylib for me) for the variable libsqlite in ddsqlite.ijs (lines 44-51). HTH, Vijay
On Thu, Nov 27, 2014 at 5:15 AM, bill lam <[email protected]> wrote: > I have never tested on any Mac, however I tested it worked fine on all > other platforms including iOS. Please let me know if the same test > database and script worked on linux or windows but failed in Mac. > On Nov 27, 2014 5:48 PM, "Jon Hough" <[email protected]> wrote: > > > Sorry I am unable to check that at the moment. I should point out that > > python can access the db without problem, using sqlite3 module I created > a > > simple py script that attempted the same SELECT query and it returned > data. > > My point being I dont think it is a database issue. > > By the way, since this was a test database it only had one table amd two > > records, and was created using sqlite browser application. > > > > --- Original Message --- > > > > From: "bill lam" <[email protected]> > > Sent: November 27, 2014 6:42 PM > > To: "Programming forum" <[email protected]> > > Subject: Re: [Jprogramming] SQLITE with Mac > > > > Will the testdb work if copied to linux and run there? > > On Nov 27, 2014 3:41 PM, "Jon Hough" <[email protected]> wrote: > > > > > > > > I got SQLITE working with J on Linux, but now I'm tryingon Mac > (Yosemite, > > > J803).I have a preexisting database which I'm trying to access. > > > ch =: ddcon__db 'database=',(jpath '~/testdb') NB. no error so far, > > > database exists in home directory. > > > query =: 'SELECT * FROM names' NB. this table name exists, and contains > > > data. > > > ddfet__db (query ddsel__db ch),1 NB. also tried with _1. > > > |domain error: cd| p=. sqlite3_column_database_name y > > > My first thought was that the table name "names" is incorrect. But it > > > isn't. And ifI exchange "names" with any old string then ddfet__db > > returns > > > _1. > > > Any help appreciated. > > > > > > ---------------------------------------------------------------------- > > > 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
