My table has a numeric type column 'TX_AMOUNT'. I want to get the value from it to a String variable. In the following code I get correct result for small numbers with
decimals. When the numbers are in large size say 6,2 (and above) in the column, the
string shows some wrong value. At the same time if the column has numbers of any size
without a decimal, it shows correct result. AT the time of insertion , I verified with a breakpoint everything is correct.
String[] columns = { helper.TX_UID, helper.TX_NAME,
helper.TX_PARTICULARS, helper.TX_AMOUNT, helper.TX_DATE,helper.TX_CONTRA};
Cursor c = db.query(VivzHelper.TX_TABLE, columns, (helper.TX_ID + "='" +
name + "' AND " + helper.TX_DATE + "= '" + td +
"'"), null, null, null,null);
gt = 0;
gt_selectedItem_number = 0;
if (c != null) {
c.moveToFirst();
while (c.isAfterLast() == false) {
String v_uid=(c.getString(0));
String txTotal = (c.getString(3));
Float fl=(c.getFloat(3));