There is no problem with sqlite: delete the sqlite folder, in PacMan, Rebuild Repository form Tools menu and install sqlite again.
To use the test.ijs script. Open it, select all (Ctrl+A) and Run Selection (Ctrl+E). Observe the session window. --- Bill Harris <[EMAIL PROTECTED]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Oleg Kobchenko <[EMAIL PROTECTED]> writes: > > > There is an update of sqlite addon that > > includes the 3.3.17 version and clarification > > in the menu that Connect opens the database > > and New/Open/Save are for the session SQL (last tab). > > > > See http://www.jsoftware.com/jwiki/Addons/data/sqlite > > Thanks! I went to PacMan and did the update; I presume that's > equivalent. FWIW, it did update from (IIRC) 1.02 to 1.04, but the > comment in PacMan still said it was 3.3.7. > > Unfortunately, when I do that, nothing works anymore. I don't have time > to troubleshoot it right now -- maybe tonight or first thing in the > morning. > > In the meantime, here's a transcript of my trying to run test.ijs in a > clean session, in case that lets you see where the problem might be: > > ,---- > | load 'c:\program files\j601\addons\data\sqlite\test.ijs' > | |domain error: cd > | | r=. sqlite_open y;c1=.,_1 > | 9!:14 '' > | j601/2006-11-17/17:05 > `---- > > FWIW, downloading it from there does seems equivalent to running PacMan; > both (downloading the three .ijs files or updating from PacMan) give the > same error. > > > For .dump, it is really a utility that probably > > best to be used from the command-line version. > > I agree; I just didn't want to ignore it, if you had programmed it into > the browser and I was missing it. > > > Optional insert works like this: > > > > insert into WORDS (WID,WVAL) > > select distinct 7,'eleven' > > from WORDS where not exists ( > > select * from WORDS where WID=7); > > Thanks; I'll try it as soon as I get SQLite working again. ____________________________________________________________________________________ Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=list&sid=396546091 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
