Updated. Thanks. On 28.11.2014, at 22:33, Vijay Lulla <[email protected]> wrote:
> 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 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
