BCD Overflow from 3.x to 4

macca · Post by **macca** » Mon 30 Jul 2007 02:35

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.

Antaeus · Post by **Antaeus** » Mon 30 Jul 2007 07:29

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.

macca · Post by **macca** » Tue 07 Aug 2007 05:55

Hi there,

I have sent an email as requested with Sample app, SQL table and Stored Proc definition.

Cheers.

Ikar · Post by **Ikar** » Wed 08 Aug 2007 11:43

We haven't received your email.
Please resend one to ikar*crlab*com.

Ikar · Post by **Ikar** » Thu 09 Aug 2007 14:02

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 ;

macca · Post by **macca** » Mon 13 Aug 2007 23:41

OK I will check that out.

Thanks for your assistance.