SQLite on Android return wrong result

Question

I'm having some troubles querying my SQLite DB from my Android APP.

This is the table I'm querying:

id | customerCode | invoiceNumber | openAmount | grossAmount

and this are the datas:

1 | 1 | 1 | -1.00 | -1.00
2 | 1 | 1 | 1.00 | 1.00
3 | 1 | 1 | 10.00 | 10.00
4 | 1 | 2 | 0.00 | 20.00
5 | 1 | 3 | 0.00 | 30.00

I'm trying to fetch only the lines which have openAmount != "0.00" and the query is:

String whereClause = MyTable.CUSTOMER_CODE + " = ? "
                + "and " + MyTable.OPEN_AMOUNT + " != \"0.00\"";

Cursor cur = mDb.query(MyTable.TABLE, null, whereClause, new String[]{customerId}, null, null, null);

The result I expect is that the query fetch the first 3 lines from my table, and this is the result I obtain if I query the DB from an external application (like SQLite Magic).

BUT... when I run the query from my Application, I obtain only the line with openAmount = -1.00.

I've tried a lot of solutions, like changing the where condition to fetch all the lines, but it seems that querying from my App not reads line 2 and 3.

I can't figure out a solution. A little help would be appreciated.

EDIT

1. All columns are TEXT.
2. It's not relevant how I iterate trhough the datas, in fact the cursor altready returns a wrong number of lines.

EDIT 2

I'm cycling though the result Cursor, and this is how i do it:

    List<MyObject> list = new ArrayList<>();
    MyObject obj;

    //initialization of columnsIndex
    //int idx1 = cur.getColumnIndex(columnName);

    if (cur.moveToFirst()) {
        do {
            obj = new MyObject();
            //set obj data
            list.add(obj);
        } while (cur.moveToNext());

    }
    cur.close();

Answer 1

Try like this:

String whereClause = MyTable.CUSTOMER_CODE + " = ? "
                        + "and " + MyTable.OPEN_AMOUNT + " NOT LIKE '0.00'";
Cursor cur = mDb.query(MyTable.TABLE, null, whereClause, new String[]{customerId}, null, null, null);