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