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
