In a database created with SQLITE Expert pro the column 'rowid' is visible in a data view and appears to behave as expected as an 'Auto-increment' INT field. Maninipulating the data with SQL commands within SQLITE Expert referencing 'rowid' also works fine, but this.....
This generates a run-time error as the column 'rowid' is not found. I could add another Int-Auto-Increment field to the table but I would like to get to the bottom of this and use rowid as the designer intended.
Has anybody else seen this behaviour?
B4X:
Dim Companies as Cursor
Cursor = SQL.ExecQuery("SELECT * FROM Companies")
Dim rowid as Int = Companies.GetInt("rowid")
This generates a run-time error as the column 'rowid' is not found. I could add another Int-Auto-Increment field to the table but I would like to get to the bottom of this and use rowid as the designer intended.
Has anybody else seen this behaviour?