-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Oleg Kobchenko <[EMAIL PROTECTED]> writes:

> There is no problem with sqlite: delete the
> sqlite folder, in PacMan, Rebuild Repository
> form Tools menu and install sqlite again.

I just did, and I get the same message.

Here's a record of the steps I took:

  Closed J

  Deleted ~addons/data/sqlite/

  Opened J (running on Windows XP SP2)

  Run > Package Manager and let it update the catalog from the server
  (NB: data/sqlite 1.04 was shown as installed)

  Tools > Rebuild all Repository Catalogs (now data/sqlite is now not
  shown as installed)

  Selected data/sqlite, and clicked Do Install...

  Here's the transcript out of PacMan:

  ,----[ PacMan log ]
  | Updating server catalog...
  | Done.
  | 1 addon can be updated, 12 addons are not yet installed.
  | The base library is up to date.
  | Updating server catalog...
  | Rebuilding local file list...
  | Done.
  | 1 addon can be updated, 13 addons are not yet installed.
  | The base library is up to date.
  | Installing 1 package of size 188 KB
  | Downloading data/sqlite...
  | Installing data/sqlite...
  | Done.
  | 1 addon can be updated, 12 addons are not yet installed.
  | The base library is up to date.
  `----

  (math/fftw is the updateable package)

  Closed PacMan

> To use the test.ijs script. Open it, select all (Ctrl+A)
> and Run Selection (Ctrl+E). Observe the session window.

  File > Open ~addons/data/sqlite/test.ijs

  (In the test.ijs window) Ctrl+a Ctrl+e

  Copied from the .ijx window:
  
,----
|    NB. sqlite test - select all Ctrl+E
|    NB. on error destroy__db'' or restart J
|    
|    require 'data/sqlite'
|    
|    sqlSummary=: 0 : 0
|   select 'S' TAB, count(*) CNT from S union
|   select 'P' TAB, count(*) CNT from P union
|   select 'SP' TAB, count(*) CNT from SP union
|   select 'J' TAB, count(*) CNT from J union
|   select 'SPJ' TABE, count(*) CNT from SPJ;
| )
|    
|    sqlSpjBySupplierAndWeight=: 0 : 0
|   select S.SNAME,P.PNAME,P.WEIGHT,J.JNAME,J.CITY
|     from SPJ,S,P,J
|    where SPJ.SID=S.SID and SPJ.PID=P.PID and SPJ.JID=J.JID
|      and SPJ.SID=? 
|      and SPJ.PID in (select PID from P where WEIGHT=?);
| )
|    
|    FDIR=: jpath '~addons/data/sqlite/'
|    'FDB FDDL FDATA'=: cut 'date.sqlite date_ddl.sql date_data.sql '
|    ferase FDIR,FDB
| 1
|    
|    ]db=: 'psqlite'conew~ FDIR,FDB
| |domain error: cd
| |   r=.    sqlite_open y;c1=.,_1
|    
`----

Running the debugger (I'm not [yet] skilled with the debugger) on
sqlite.ijs and setting dbstop'sqlite', I get

,----[ Debugger top pane ]
|  >[0] 15!:0
`----

,----[ Debugger middle pane ]
| domain error
| cd[0] 15!:0
| sqlite_open[0] '"c:\program files\j601\addons\data\sqlite\lib\sqlite3.dll" 
sqlite3_open >+ i *c *i'&cd
| create__w[3]   r=. sqlite_open y;c1=. ,_1
| conew[1] create__w x
`----
  
,----[ Debugger bottom pane ]
| 
`----

I'm sure I'm doing something dumb, but I can't see what it might be.
Does this provide any help?

Bill
- -- 
Bill Harris                      http://facilitatedsystems.com/weblog/
Facilitated Systems                              Everett, WA 98208 USA
http://facilitatedsystems.com/                  phone: +1 425 337-5541
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: For more information, see http://www.gnupg.org

iD8DBQFGZCx53J3HaQTDvd8RAhvFAJ9rJplzXhEtxxKr7bOBzNvkgOZO1gCdEDZb
X7sh6wWGOF8ciHDvc1msNPA=
=zsHQ
-----END PGP SIGNATURE-----

----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm

Reply via email to