vbRichClient Create Table AUTO_INCREMENT

[axisdj]

Hello,

Finally working with the vbrichclient SQL lite stuff ( never thought I would)...

Really Awesome framework.

I am able to create the table in a DB (file) I need and fill it with data, but in my case I need the ID/ primary key to be auto generated.

so when I do the .setInt32, or on the creating of the table how do I make it so the ID field is automatically generated?

Thanks

[axisdj]

Think I found it, call LastInsertAutoID on cConnection Object?

WP

[jpbro]

SQLite tables automatically create a field called "rowid" (unless WITHOUT ROWID) is specified that acts as a unique # for each row. Alternately, you can create your own autonumber column by declaring the field with INTEGER PRIMARY KEY keywords (e.g. CREATE TABLE mytable (myfield INTEGER PRIMARY KEY).

You don't need to set the value for these fields with SetInt32 or anything - just leave it out of any INSERT/UPDATE statements/commands and a # will be generated automatically.

See here for more info: https://sqlite.org/lang_createtable.html#rowid

[Carlos Rocha]

Adding to what jbpro said:

by declaring "myfield INTEGER PRIMARY KEY", myfield become just an alias to the internal "rowid".
by declaring "myfield INTEGER PRIMARY KEY AUTOINCREMENT", sqlite guaranties that every new row will have a rowid that was never used before in that table.