search

robertohuertasm / SQLite4Unity3d

SQLite made easy for Unity3d
MIT License
1.28k stars 265 forks source link

Primary Key column results always 0? #72

Closed hellocld closed 7 years ago

hellocld commented 7 years ago

Whenever I query my database for all (or any) entries in a table, I'm able to see all data in each column of each row except for the primary key column, which is always 0 in each entry. Loading the database into a viewer (DB Browser for SQLite) I see the values are there.

The column is configured as "INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL".

Is there something specific to SQLite that does not let me view the values of this column when configured this way, or do I need to pass something specific in a query to see this data?

hellocld commented 7 years ago

Resolved. There was something wrong with by database file; started a fresh one and was able to get the ROWID values without issue. Not sure exactly what the problem with the previous database file was, will post more if I find out.