[sqlite] autoincrement field

[Levente Kovacs]

I have a table structure like this:

CREATE TABLE padstack (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        pin_number INTEGER,
        name TEXT
);

Is there any way to get the 'id' of newly inserted row? My insert of course
not contains the 'id' field.

Thanks,
Lev