Just verify that the DataType and Value.Type properties are set correctly. I have noticed that if you change a parameter value these properties previous values get deleted and revert back to ftUnknown and NULL. Other than that, I haven't experienced any issues with them. Have you tried setting the Parameter types at runtime before executing the procedure?
JED >Further to the below, I also tried creating the ADODB object via COM and >it worked fine, so its obv. an issue with the ADO components >somewhere...GREAT. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the [EMAIL PROTECTED] ********************************************************************** --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/