I guess that btrieve database has already serviced for 20 to 30 years. Is the H1.RYN a mssql, oracle? or xtrive!? Anyways I suggest use ddcol to examine the column type of the stockprice table. Current dd does not handle all odbc types.
Вск, 05 Сен 2010, Steven Taylor писал(а): > Hi Jers, > > I decided to use J for some tests... I tried to pull some data in from a non > standard btrieve style database (to be retired), so probably this isn't a J > problem, but just wondered if anyone had seen this. It's my first time using > J's ODBC drivers. This error occurs when pulling a date column over. The > error is: "ISI10 Unable to bind all columns - more error info available > (2)". All indications are it is a data type issue. So, my next step is to do > a cast in SQL to double + try the same against some of the more well > known databases. > > Below is a quick script for illustration purposes. In the below s1 works, > but s2 returns the ISI10 error. > > load 'dd' > [ch=. ddcon 'dsn=H1.RYN;modifysql=0' > s1=.'select top 100 id,priceclose from dbo.StockPrice' > s2=.'select top 100 id,tdate,priceclose from dbo.StockPrice' > > sh1=. s1 ddsel ch > [r1=.ddfet sh1,_1 > sh2=. s2 ddsel ch > [r2=.ddfet sh2,_1 > > NB. ddfch doesn't work for either s1 or s2. > > thanks, > -Steven -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
