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
