Page 1 of 1
BCD Overflow from 3.x to 4
Posted: Mon 30 Jul 2007 02:35
by macca
Hi there,
I have just upgraded to the driver V4.x from 3.x.
I am now receiving a BCD overflow error when calling a Stored Proc with a currency input.
Environment is D7 connecting to SQL Server 2000.
What has changed between the two versions that could be providing this error?
Thanks in advance.
Posted: Mon 30 Jul 2007 07:29
by Antaeus
Please describe this problem in more details:
- specify a value that causes this error;
- when does this problem appear (design time/run time)?
- what actions do you perform?
- do you use preparation?
- what is the definition of your stored procedure;
- what is the exact version of your SDAC. You can see it in the About sheet of TMSConnection Editor.
It would be better if you send me a complete small sample at evgeniyD*crlab*com to demonstrate the problem, and the script to create your stored procedure.
Posted: Tue 07 Aug 2007 05:55
by macca
Hi there,
I have sent an email as requested with Sample app, SQL table and Stored Proc definition.
Cheers.
Posted: Wed 08 Aug 2007 11:43
by Ikar
We haven't received your email.
Please resend one to ikar*crlab*com.
Posted: Thu 09 Aug 2007 14:02
by Ikar
Thank you for the example.
We reproduced the problem. The problem is in Borland SqlExpr code. To avoid it you should use
Code: Select all
ParamByName('paymentAmount').AsBCD := 5.00 ;
instead of
Code: Select all
ParamByName('paymentAmount').AsCurrency := 5.00 ;
Posted: Mon 13 Aug 2007 23:41
by macca
OK I will check that out.
Thanks for your assistance.