sqlLite Row ID

Jay_Menna · August 26, 2016, 1:35pm

Newbe to sqllite

I’m trying to access the row ID of a database with the built-in row did of sqlite

In mysql i would call

RS.Field(“ID”).IntegerValue where there is a user defined fields called “ID”

Is it possible to call the database created rowid of MySQL?

Calling:

RS.Field(“rowid”).IntegerValue

Throws an exception.

Tim_Parnell · August 26, 2016, 1:40pm

You have to specifically select the rowid in the SELECT statement.
(even when using SELECT * it would be SELECT rowid, *) source

It is commonly recommended not to use the SQLite rowid and use your own ID column.

Kem_Tekinay · August 26, 2016, 2:31pm

Tim is so good, he has answers to questions that were never asked…

Mark_Walsh · August 26, 2016, 4:10pm

Then again, since the question was never asked, who are we to assume that the answer was correct?

brian_franco · August 26, 2016, 4:39pm

What if the never asked question was wrong?

Tim_Parnell · August 26, 2016, 4:41pm

The question was how to get rowid, because Recordset.Field(“rowid”) was having an error.

I’m not sure why the original question was deleted, it was a good question.

Kem_Tekinay · August 26, 2016, 5:24pm

Clearly your answer was so good, it blew his mind and he couldn’t risk that happening to others.