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
