Dear Sirs,
I found that when opening SQLite tables with external programs usually I see field named rowid. Do I need to create my own Primary Key field in a table or is there already an existing rowid field (with TLiteTable)?
I could not find any.
Michał
internal rowid field
Re: internal rowid field
Description of working with the special ROWID field in SQLite is available at https://www.sqlite.org/lang_createtable.html#rowid.
The special ROWID field is used by SQLite for its own purposes and doesn't substitute the primary key. In order for a table to have a primary key, you should create it explicitly: https://www.sqlite.org/lang_createtable ... imkeyconst
The special ROWID field is used by SQLite for its own purposes and doesn't substitute the primary key. In order for a table to have a primary key, you should create it explicitly: https://www.sqlite.org/lang_createtable ... imkeyconst