Solved

What's BCD?

Posted on 2001-08-21
8
531 Views
Last Modified: 2010-04-06
Hi.

I'm getting this error message....

---------------------------
Debugger Exception Notification
---------------------------
Project earestore.exe raised exception class EBcdOverflowException with message 'BCD overflow'. Process stopped. Use Step or Run to continue.
---------------------------
OK   Help  
---------------------------

Does this make any sense to anyone?

John.
0
Comment
Question by:Jaymol
8 Comments
 
LVL 27

Accepted Solution

by:
kretzschmar earned 50 total points
ID: 6411246
bcd is a specific numeric format,
if u use the bde there is a setting
for handling/interpreting bcd-fields
called enable bcd

the default setting is false

maybe this setting causes the problem
(if u use the bde)

meikl ;-)
0
 
LVL 5

Expert Comment

by:scrapdog
ID: 6411278
Binary Coded Decimal, which means that there are 10 possible values per nybble (rather than 16).  Therefore, one byte would represent a number from 0-99 rather than 0-255.

BCD is usually used in accounting applications, where computing in base 10 is typically easier than computing in base 16.

0
 
LVL 17

Expert Comment

by:inthe
ID: 6412275
hi,
maybe you are using the d6 math unit?
do you know where in the code it happpens?
if not madshis madexception will (9/10 times) tell you the line number so you can see where the problem may be.

0
 
LVL 6

Author Comment

by:Jaymol
ID: 6412414
The problem occurs when executing a stored procedure, but as you can see it's not a DB exception that I get, but a Delphi exception.

I'm using a TSQLConnection and TSQLStoredProc component to achieve this.

Any ideas?

Can I just turn this off somehow?

John.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 6

Author Comment

by:Jaymol
ID: 6412579
Oh yeah, I'm not using a BDE alias, but an ODBC DSN.

John.
0
 
LVL 6

Author Comment

by:Jaymol
ID: 6421220
Thanks guys.
0
 
LVL 5

Expert Comment

by:Karitz
ID: 7882144
Was faced with a similar problem with delphi 6. Interestingly when I do not use the maths unit it works fine...when I use it I get the error....

I just concluded it might be a bug......
0
 
LVL 6

Author Comment

by:Jaymol
ID: 7902017
I've come across a few bugs in Delphi, over the years, and Borland have always suggested I pay them to look into it, with the view of refunding me afterwards if it is their problem.

Hmmmm.....not really a difficult choice, especially at their rates!  I've found EE to be better than Borland's support.  Hell - the internet's better than Borland's support!

SQL queries have always been a problem and I've only recently found a way to work that I'm happy with - using access databases and ADO connections (using the Delphi ADO components).  I find it probably the most stable (other than Oracle or SQL Server) and it's also very SQL friendy, if you've got up to date JetSQL.

John.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Virtuailstring tree compare node issue 14 105
delphi parse string to params 3 101
Base1 Encode/Decode 3 68
How to build JSON File in Delphi 6 3 17
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now