See my previous e-mail: I was querying temp.sqlite_sequence when I thought I
was querying main.sqlite_sequence.
Will
On 11/16/10 2:22 PM, "Richard Hipp" wrote:
On Tue, Nov 16, 2010 at 4:31 PM, Duquette, William H (316H) <
william.h.duque...@jpl.nasa.gov> wrote:
> Yes. I've done a couple of
On Tue, Nov 16, 2010 at 4:31 PM, Duquette, William H (316H) <
william.h.duque...@jpl.nasa.gov> wrote:
> 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.
>
Test case:
CREATE TABLE
Aha!
I've got AUTOINCREMENT keys in both regular and temporary tables. This results
in
two sqlite_sequence tables, one in sqlite_master and one in sqlite_temp_master.
And evidently, if I have a permanent and a temporary table with the same name,
a query that doesn't specify gets the temporary
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" wrote:
On 11/16/2010 2:14 PM, Duquette, William H (316H) wrote:
> Howdy!
>
> According to th
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
>
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 ide
6 matches
Mail list logo
