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/

Reply via email to