OOPS! There was a typo in my path. It should be 'libsqlite3.dylib' and not 'libsqlie3.dylib'. Sorry.
On Fri, Nov 28, 2014 at 1:41 AM, bill lam <[email protected]> wrote: > Thanks Vijay, ddsqlite updated to check for /opt/local/lib/libsqlie3.dylib > > Please report if this patch will cause any regression. > > > Чт, 27 ноя 2014, Vijay Lulla написал(а): > > 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 > > -- > regards, > ==================================================== > GPG key 1024D/4434BAB3 2008-08-24 > gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 > gpg --keyserver subkeys.pgp.net --armor --export 4434BAB3 > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
