sqlbulkoperations needs a cursor for working, however insert statement
cannot open a cursor. Therefore the sql for ddins is
select foo,bar from foobar
please amend your query and test again.
Птн, 18 Июн 2010, Denis Samson писал(а):
>
>
> 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
--
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
