|
From: Warren, J. <wa...@kb...> - 2007-08-17 16:57:14
|
Hi,=20
I don't suppose anyone would have a way to bulkcopy in NULL values?
For example (__version__ =3D '0.38') :-
from Sybase import *
c =3D connect ('TEST_DS', 'sa', 'password', bulkcopy=3D1, auto_commit=3D1)
c.execute("CREATE TABLE #t1 (a int, b INT NULL)")
b=3Dc.bulkcopy('#t1')
for r in range(32):
b.rowxfer([r,None]) # None represents NULL when selected or
bulkcopied out
if r %5 =3D=3D 4:
ret =3D b.batch()
ret =3D b.done()
This results in :-
Sybase.Error: blk_rowxfer_mult in
Many thanks,
James.
--=20
This message may contain confidential, proprietary, or legally privileged i=
nformation. No confidentiality or privilege is waived by any transmission t=
o an unintended recipient. If you are not an intended recipient, please not=
ify the sender and delete this message immediately. Any views expressed in =
this message are those of the sender, not those of any entity within the KB=
C Financial Products group of companies (together referred to as "KBC FP").=
=20
This message does not create any obligation, contractual or otherwise, on t=
he part of KBC FP. It is not an offer (or solicitation of an offer) of, or =
a recommendation to buy or sell, any financial product. Any prices or other=
values included in this message are indicative only, and do not necessaril=
y represent current market prices, prices at which KBC FP would enter into =
a transaction, or prices at which similar transactions may be carried on KB=
C FP's own books. The information contained in this message is provided "as=
is", without representations or warranties, express or implied, of any kin=
d. Past performance is not indicative of future returns.
|