allow to use _rowid_ as normal field

Question

Opened this issue 7 years ago · 3 comments

is there a way to select "rowid" just like any other field of a table?

orma.selectFromTable()._rowid_Eq(myrowid)....

or update with rowid

orma.updateTablex()._rowid_Eq(myrowid)....

Answer 1 · 2017-06-01T11:34:26.000Z

It's possible if you declare the field.

Answer 2 · 2017-06-01T12:37:42.000Z

how can i declare rowid? this is already sqlite internal

Answer 3 · 2017-06-01T12:56:42.000Z

Just declare @PrimaryKey long <your favorite name> which is an alias to _rowid_.

If a table contains a column of type INTEGER PRIMARY KEY, then that column becomes an alias for the ROWID.