Insert returns int type, but ROWID is always signed 64-bit integer in sqlite.
Issue #147
closed
Let me understand, please.
Insert returns int type, but ROWID is always signed 64-bit integer in sqlite ( https://www.sqlite.org/rowidtable.html )
Does it mean SQLite-Net Extensions can’t operate fully on rowid ?
Can't insert more than 2 to 32 records in a table?
Comments (3)
-
-
- changed status to closed
-
reporter Thank you very much for your answer. I asked timidly, fearing that I might have missed something obvious. So this is quite a bug in SQLite-Net. I've always thought that type compatibility is essential in programming.
- Log in to comment
While your statement is true, this limitation is inherited from SQLite-Net and there’s nothing we can do about it. As you can see in their source code the
Insert
method returns an integer. SQLite-Net Extensions extends SQLite-Net adding some convenience methods for handling relationships, so we’re limited to the datatypes returned by SQLite-Net itself.