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 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
