Android Question ROWID in SQL query

[strupp01]

I want the line no. (Several) from a table 'BRP' and the column 'Plus_Zeit', which contain the value '0.0'. With the command
"SELECT Plus_Zeit, ROWID FROM BRP where Plus_Zeit = '0.0'"
I get the number of rows but not the row no. (ROWID).

How must the command look right?

 

[ronell]

can you show us the relevant code? you sure the column name is "ROWID" ?

 

[strupp01]

ROWID is the internal column name of SQL for the number of records. I did not create a column ID number with the command 'AUTO_INCREMENT' when creating the table.

This is an excerpt from the table with a DB browser.

 

[Mahares]

Use cursor1.getint("rowid") . Use lower case for the rowid.

 

[Smee]

I always use lower case for rowid and I always put it at the beginning of a query, not sure if it makes a difference though

 

[strupp01]

Thank you Mahares,
that is the solution.