Doubles returned and bound to list view are truncated

Question

I am query my sqlite data base for my Android app.

I then use a simple cursor adapter to bind the data to a list view.

there are two doubles being called from the database and on the list view the only show up as 6 digits long.

Example: 43.6234 and -116.203

in the database (I dumped it) these numbers have a lot more digits.

What went wrong? Here is my row XML for the list view

<?xml version="1.0" encoding="utf-8"?>
    <RelativeLayout android:id="@+id/relativeLayout2" android:layout_width="fill_parent" android:layout_height="fill_parent" xmlns:android="http://schemas.android.com/apk/res/android">
        <TextView android:text="@string/ssid" android:layout_width="wrap_content" android:layout_height="wrap_content" android:id="@+id/row_db_ssid" android:textSize="16dip"></TextView>
        <TextView android:layout_height="wrap_content" android:layout_below="@+id/row_db_bssid" android:textSize="12dip" android:text="@string/lati" android:layout_width="wrap_content" android:id="@+id/row_db_latitude"></TextView>
        <TextView android:text="@string/bssid" android:layout_width="wrap_content" android:layout_height="wrap_content" android:id="@+id/row_db_bssid" android:layout_below="@+id/row_db_ssid" android:textSize="14dip"></TextView>
        <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_alignParentRight="true" android:text="@string/rssi" android:textSize="16dip" android:id="@+id/row_db_rssi"></TextView>
        <TextView android:layout_height="wrap_content" android:layout_alignParentRight="true" android:layout_below="@+id/row_db_bssid" android:textSize="12dip" android:text="@string/longi" android:layout_width="wrap_content" android:id="@+id/row_db_longitude"></TextView>
    </RelativeLayout>

when you created database what was the syntax of create query for this table? may be possible you have given some more precise holder for these. — Ravin, Apr 16 '11 at 07:08
`"create table scanned (_id integer primary key autoincrement, " + "ssid text, " + "essid text, " + "latitude double, " + "accuracy float, " + "longitude double, " + "rssi integer);";` — Seth Hikari, Apr 16 '11 at 07:29
Like I said though, I checked the contents of the table and the numbers were correct. — Seth Hikari, Apr 16 '11 at 07:30
and what about fetching these from database? are you assigning them somewhere in low precision data type? — Ravin, Apr 16 '11 at 07:33
No I query them as is, and give the cursor to the `SimpleCursorAdapter` I have tried to look through the cursor variable during a break point to see if it was low precision before given to the list, but I could not find the row data ( I am sure it is there ) in the cursor. It is very big object — Seth Hikari, Apr 16 '11 at 07:38
After looking here: http://krysanify.wordpress.com/2010/11/24/simplecursoradapter-and-its-flaw/ I have found a flaw in the `SimpleCursorAdapter` that just assumes the fields will be strings loosing the precision wanted. — Seth Hikari, Apr 16 '11 at 08:09

score 0 · Accepted Answer · answered Apr 17 '11 at 05:03

After looking here: krysanify.wordpress.com/2010/11/24/… I have found a flaw in the SimpleCursorAdapter that just assumes the fields will be strings loosing the precision wanted

I extended the SimpleCursorAdapter to use Double on the rows I wanted here is the class.

public class WithLongAdapter extends SimpleCursorAdapter {
    private int[] mFrom;
    private int[] mTo;
/**
 * SimpleCursorAdapter that also checks for Double values based on rows so they will not be truncated
 * @param context pass this
 * @param layout the row file
 * @param c the Cursors
 * @param from collums on cursor
 * @param to rows on list
 */
    public WithLongAdapter(Context context, int layout, Cursor c,
            String[] from, int[] to) {
        super(context, layout, c, from, to);
        mTo = to; //have to make my own to and from because they are protected in SimpleCursorAdapter
        if (c != null) {
            int i;
            int count = from.length;
            if (mFrom == null || mFrom.length != count) {
                mFrom = new int[count];
            }
            for (i = 0; i < count; i++) {
                mFrom[i] = c.getColumnIndexOrThrow(from[i]);
            }
        } else {
            mFrom = null;
        }
    }

    @Override
    public void bindView(View view, Context context, Cursor cursor) {
        final ViewBinder binder = getViewBinder();
        final int count = mTo.length;
        final int[] from = mFrom;
        final int[] to = mTo;

        for (int i = 0; i < count; i++) {
            final View v = view.findViewById(to[i]);
            if (v != null) {
                boolean bound = false;
                if (binder != null) {
                    bound = binder.setViewValue(v, cursor, from[i]);
                }

                if (!bound) {
                    String text = cursor.getString(from[i]);
                    if (text == null) {
                        text = "";
                    } else if (R.id.row_db_latitude == v.getId()) { //added rows, if they are the ones I want get value of doulbe
                        text = String.valueOf(cursor.getDouble(from[i]));
                    }
                    else if (R.id.row_db_longitude == v.getId()) { //added row
                        text = String.valueOf(cursor.getDouble(from[i]));
                    }
                    if (v instanceof TextView) {
                        setViewText((TextView) v, text);
                    } else if (v instanceof ImageView) {
                        setViewImage((ImageView) v, text);
                    } else {
                        throw new IllegalStateException(
                                v.getClass().getName()
                                        + " is not a "
                                        + " view that can be bounds by this SimpleCursorAdapter");
                    }
                }
            }
        }
    }
}

Doubles returned and bound to list view are truncated

1 Answers1