sqlite3: Select rowid with SQLiteDatbase instance

Question

Is there a way for selecting the rowid from table using SQLiteDatabase instance

Cursor websiteCursor= mDatabaseManipulator.query(mTableName, null, COLUMN_WEBSITENAME+"='"+websiteName+"'", null, null, null, null);

Above cursor doesn't get the rowid. The doc says passing null in second argument will return all columns. But rowid is not returned.

I m getting rowid using rawQuery.

Cursor websiteCursor = mDatabaseManipulator.rawQuery("Select rowid _id, * from " + mTableName + " where " + COLUMN_WEBSITENAME + " = '" + websiteName +"'", null);

How do you know the rowid is not returned? Note that rowid is just an alias for the integer primary key column if there's one. — laalto
– laalto, Commented Dec 30, 2013 at 12:07
In your raw query, you do not get the rowid with * but have to list it explicitly, too. — CL.
– CL., Commented Dec 31, 2013 at 13:00

Rohan Kandwal · Accepted Answer · 2013-12-30 14:25:13Z

1

I think there is some problem in the way that you are implementing the cursor, try this :-

Cursor websiteCursor= mDatabaseManipulator.query(mTableName, new String[]{rowid_id}, COLUMN_WEBSITENAME+" =? ", new String[]{websiteName}, null, null, null);

answered Dec 30, 2013 at 14:25

Rohan Kandwal

9,3268 gold badges77 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sqlite3: Select rowid with SQLiteDatbase instance

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related