tony.x.yeatman at jpmorgan.com
tony.x.yeatman at jpmorgan.com
Thu Feb 2 12:02:31 CST 2006
I am issuing the following SQL string against an Oracle 9i database, and
it is erroring because of the Null.
strSQL is equal to:
INSERT INTO TBLLOADDATA
(LOADFILEID, A01, A02, A03, A04, A05, A06, A07, A08, A09, A10,
A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21, A22, A23, A24, A25,
A26, A27, A28, A29, A30)
VALUES
('83','CCC','N','8642378','2663099','8642378','2663099','AAAAAA','BBBBB','26630990','SP','317','20060201',Null,'0','0','1.212200000','20060203','VVV',
'B','YYY','150000.000000000','ZZZ','181830.000000000','1.212200000','.000000000','1.212200000','.000000000','.000000000','20060201','0
')
If in Immediate window I issue strSQL = "INSERT.... " etc (effectively
resetting the variable) it runs just fine
I do have a function that is returning the Null as a string (I have also
tried as a variant)
Does anyone know how I could do the same through code ?
Thank you for any help you can give.
Tony
This communication is for informational purposes only. It is not intended
as an offer or solicitation for the purchase or sale of any financial
instrument or as an official confirmation of any transaction. All market prices,
data and other information are not warranted as to completeness or accuracy and
are subject to change without notice. Any comments or statements made herein
do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries
and affiliates