Yes.  I've done a couple of inserts into the table, interspersed with queries 
to the
sqlite_sequence table; they show the sqlite_sequence table as being empty.

Will


On 11/16/10 1:29 PM, "Gerry Snyder" <[email protected]> wrote:

On 11/16/2010 2:14 PM, Duquette, William H (316H) wrote:
> Howdy!
>
> According to the docs on sqlite.org, a table with "INTEGER PRIMARY KEY 
> AUTOINCREMENT" gets an entry in the sqlite_sequence table.  I've got some 
> code that contains such a table; but if I query the sqlite_sequence table I 
> don't see it being updated; it's always empty.  Anyone have any idea what's 
> going on?
>

Have you put anything in the table that is

INTEGER PRIMARY KEY AUTOINCREMENT

so there is a sequence number to store in sqlite_sequence?

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

--
Will Duquette -- [email protected]
Athena Development Lead -- Jet Propulsion Laboratory
"It's amazing what you can do with the right tools."

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to