Hi, While following the example page for the JDB's Northwind database in <http://www.jsoftware.com/jwiki/JDB/Examples> I hit the following snag: load 'data/jdb' load 'data/jdb/northwind' db_demo '' load 'csv ~user/jdb/jdb.ijs' |file name error: script | 0!:0 y[4!:55<'y' This can be easily fixed by editing northwind.ijs in right about here: NB. ========================================================= NB. Smoke Test: db_demo '' or run by line: Ctrl+E db_demo=: (showx;._2) bind (0 : 0) NB. load 'csv ~user/jdb/jdb.ijs' load 'csv data/jdb' db_init DBPATH Reads__D 'from Categories' Reads__D 'from Suppliers where Country=UK' Reads__D '** from Products where Categories.CategoryName=Beverages' Reads__D 'from Products where Suppliers.CompanyName=Exotic Liquids' Reads__D 'from Products where UnitPrice<10' Reads__D 'Categories.CategoryName from Products where Suppliers.Country=UK' Reads__D 'from Customers where Country=UK' Reads__D 'from Employees where Country<>UK and HireDate>19930000' Reads__D 'from Shippers' Reads__D 'from Orders where Customers.Country=UK and Employees.Country=UK and ShipperID=1' Reads__D 'from OrderDetails where Customers.Country=UK and Quantity>60' Reads__D 'count:count autoid by Country from Suppliers' Reads__D 'min:min UnitsInStock,max:max UnitsInStock by Suppliers.Country from Products' ReadCols__D'Products' db_close'' )
Its trivial but might trip a newbie ... r/Alex ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
