[AccessD] SQL String - Executed against Oracle by ADO

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




More information about the AccessD mailing list