CODEWITHSUNDEEP
androidsqlite
neknek mouh
neknek mouh

Reputation: 1802

Concatenate 2 columns Android SQLite

So far I have this: 

    Cursor cursor = dbHelper.getAllPatients();
    String[] data = new String[]{DBHelper.KEY_LNAME, 
            DBHelper.KEY_FNAME, DBHelper.KEY_DIAGNOSIS};

    int[] to = new int[] {R.id.fullname, R.id.diagnosis};

    dataAdapter = new SimpleCursorAdapter(this, R.layout.custom_row, cursor, data, to, 0);
    dbHelper.close();

    lv.setAdapter(dataAdapter);
    lv.setTextFilterEnabled(true);

getAllPatients() method

  public Cursor getAllPatients()
{
    Cursor localCursor = 
            this.myDataBase.query(DB_TABLE, new String[] { 
                    KEY_ID, KEY_FNAME, KEY_LNAME, KEY_DIAGNOSIS }, null, null, null, null, null);
    if (localCursor != null)
      localCursor.moveToFirst();
    return localCursor;
}

I want the columns FNAME, and LNAME to be as one but I'm confused how and where to put the concatenate operator + in the String array. Do you have any idea to do this? I would gladly appreciate your help. Thanks.

Upvotes: 1

Views: 1447

Answers (2)

Muhammad Riyaz
Muhammad Riyaz

Reputation: 2942

Do the following when you query

Cursor localCursor = 
        this.myDataBase.query(DB_TABLE, new String[] { 
                KEY_ID, KEY_FNAME +"||"+ KEY_LNAME, KEY_DIAGNOSIS }, null, null, null, null, null);

And while assigning values using your adapter do as follows,

String[] data = new String[]{DBHelper.KEY_LNAME +"||"+ DBHelper.KEY_FNAME, DBHelper.KEY_DIAGNOSIS};

int[] to = new int[] {R.id.fullname, R.id.diagnosis};

Upvotes: 2

Benil Mathew
Benil Mathew

Reputation: 1634

try this 

SELECT CONCAT(ColA, ColB) AS ColC FROM Table

or 

String query = "select" +ColA+"+"+ColB +"as CompleteAddress from YourTable";

Upvotes: 0

Related Questions