indoaryaan
IS-IT--Management
Hello, I am using SqlBase 7.0 with a Java application. An Amount column in a table(in SqlBase) was defined as Amount(8,2) with Decimal datatype. The java application used to access the database and fetch the data through a regular SQL "Select" query. I changed the column width and set it to Amount (12,2) with Decimal datatype. Now when the java aplication tries to get a 7 digit ( million + ) amount, the amount shows up with just 5 digits only. This happens only when the amount is ending with Zeros in the database. E.g 1000000.00 or 1000000 and the fetch would retrn and display only 10000. If the amount ends with 2 decimal points such as 1000000.01 or 1000000.99, the amount is fetched and displayed correctly as in database. Any help on this would be highly appreciated. Thanks .......