Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.

Public Report
Report From: C#Builder/Data Access/Data Provider/bdpDataReader    [ Add a report in this area ]  
Report #:  33051   Status: Reported
loosing decimal precision when reading from database
Project:  C#Builder Build #:  10.0.2288.42451
Version:    10.0 Submitted By:   Peter Ghyselincks
Report Type:  Crash / Data loss / Total failure Date Reported:  8/23/2006 2:29:31 PM
Severity:    Critical / Show Stopper Last Updated: 10/21/2006 4:14:34 PM
Platform:    All platforms Internal Tracking #:  
Resolution: None  Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: 1
Description
field type: system.decimal
databases: access, interbase
same results using explorer, adapter + datagrid, bdpdatareader


Steps to Reproduce:
Case 1:
using dataexplorer
view a table in an access database (or interbase database) containing fields of type decimal. Specific values within fields: 0,01 or   0,1  or  1  or  10
data is viewed as  1 and 1 and 1 and 10

Case 2:
using Datagrid in ECO application
same results

Case 3:
using bdpdatareader in ECO application
same results

When modifying data in the application results in correctly stored data in the databases.
When reading data from the database, data is corrupt.
Workarounds
Change the Digit Grouping Symbol in your regional settings from  ','(comma) or '.' (point)  to ' ' (space)



:-)
Attachment
bug_decimal.zip
Comments

None

Server Response from: ETNACODE01