Bill,I updated my 32-bit J 6.02a, and tried ddins again... Got the same result
I had under 5.03, with the [quite predictable, I'm afraid] error about data not
bound to
columns before trying to execute...
Just for the sheer thrill, I'll try to do the same ddins with MS Access or any
other
DB I can get my hands on... stay tuned!
Denis=============================================================
NB. freshly updated j602a
load 'dd'
iad_jdd_
┌─┬─┬─────────────────────────────────────────────────┐
│3│:│ple=. 15!:6 <y NB. pointer to local entry│
│ │ │pa=. memr ple,SZI,1 4 NB. ptr to array │
│ │ │''$pa+memr pa,0 1 4 NB. plus offset to data │
└─┴─┴─────────────────────────────────────────────────┘
IF64, SZI_jdd_
0 4
]ch=: ddcon 'dsn=CalgaryBus'
54955696
ddfch _1,~ 'select * from CalgaryBus0.DIRECTION' ddsel ch
┌─┬────────────────────────────────────────┐
│0│Clockwise │
│1│East │
│2│North │
│3│South │
└─┴────────────────────────────────────────┘
$ each ddfch _1,~ 'select * from CalgaryBus0.DIRECTION' ddsel ch
┌───┬────┐
│4 1│4 40│
└───┴────┘
new=: (,.4 5 6);>40{.&.>'Up';'Down';'Random'
]lh=:'insert into CalgaryBus0.DIRECTION values(?,?)';new
┌─────────────────────────────────────────────┬─┬────────────────────────────────────────┐
│insert into CalgaryBus0.DIRECTION values(?,?)│4│Up
│
│ │5│Down
│
│ │6│Random
│
└─────────────────────────────────────────────┴─┴────────────────────────────────────────┘
$ each lh
┌──┬───┬────┐
│45│3 1│3 40│
└──┴───┴────┘
lh ddins ch
_1
dderr ch
07001 506 [MySQL][ODBC 5.1 Driver][mysqld-5.0.32-Debian_7etch11-log]
SQLBindParameter not used for all parameters
dddis ch
0
_________________________________________________________________
MSN Dating: Find someone special. Start now.
http://go.microsoft.com/?linkid=9734384
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
