> I am using an ADO stored proc to call a stored proc on a MSSQL
> One of the parameters in the stored proc on the server is a
> Decimal(28,20) but delphi detects this in the parameters list and
> sets it to ftBCD, precision 28, scale of 20.
It sounds like you are using the stored procedure component, and some
data conversion is going wrong. Unless you are using data aware controls
or something, you can build the command and parameter list for the stored
procedure as a simple widestring and use the EXECUTE method in the
connection to run it. You can get a result set and read it as string
numerics, to get whatever precision you need.
ADO only deals in ASCII, not numerics, all conversions to internal SQL
data types take place in ADO or SQL itself, not Delphi.
To unsubscribe or change your settings for TWSocket mailing list
please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket
Visit our website at http://www.overbyte.be