Dear Nadya,

Thank you for your reply .... According your question, I try to change the program without using "CInt and CStr" and remove nRec variable. But the error message still showed when execute the program. I don't know how to debug the store procedure, therefore, I can't know what value pass into store procedure. Do you know how to debug the store procedure? Do you any idea to solve the problem? 1000 Thanks!!

Best Regards,

Justy Chow