How can I compare two strings from different tables in same SQLite database?

Asked Oct 24 '14 at 19:41

Active Oct 24 '14 at 19:41

Viewed 26 times

I tought it would be something like this:

Cursor c = contactDBHelper.listOne(id);
    Cursor d = contactDBHelper.listOneText();

    if(c.moveToFirst()){
        do{
            if(c.getString(5).toString() == d.getString(1).toString()){
                txt.setText(d.getString(1));

            }else{
                customR.setChecked(true);
                txt.setText(c.getString(5));    
                standardR.setChecked(false);
            }


        }while(c.moveToNext());
    }

But apperently its not. Anyone got any tips on how to accomplish this?

asked Oct 24 '14 at 19:41

The Dude

1,088
7
16
30

Always use `equals` method instead of `==`. It will give you more precise answer than `==`. – Vighanesh Gursale Oct 24 '14 at 19:42
Sorry. thats what I had first. Didnt work – The Dude Oct 24 '14 at 19:43
Sorry. Had that at first. Didnt work. Please unmark this question so i can edit it. The solution linked as duplicated does not work in my case – The Dude Oct 24 '14 at 19:45
try to print both `strings` if they don't match. – Vighanesh Gursale Oct 24 '14 at 19:45
If the `String`s are not `equal`s then there's a problem with your `String`s. Try to print them out and wrap them between `"` to check if there are no blank spaces. – Luiggi Mendoza Oct 24 '14 at 19:47
After some debugging I found out the problem is I cant reach d.getString(), am I not allowed to have 2 Cursors? – The Dude Oct 24 '14 at 19:56
if `c.moveToFirst` returns false that means there is nothing in your cursor – tyczj Oct 24 '14 at 20:00
The problem is to get the string from cursor D – The Dude Oct 24 '14 at 20:01
Probably you need to execute `d.moveToFirst()` as well... ? – Luiggi Mendoza Oct 24 '14 at 20:06
@user2927356 : You're taking the wrong approach by using two `Cursors`. Use a conditional query with a single `Cursor`. Something along the lines of `SELECT TABLE1.some_column, TABLE2.other_colomn WHERE TABLE1.some_column = TABLE2.other_column`. The dataset returned to the `Cursor` will then contain 0 or more rows. – Squonk Oct 24 '14 at 21:05

How can I compare two strings from different tables in same SQLite database?

0 Answers0