Did a bit more digging, and the code I wrote is doing what its supposed to do. There is (what I'm calling) a bug with the string handling in the wrapper (That I didn't write) I'm using that doesn't know how to deal with "strings" type, but it does work fine with ansistrings, and I think the translation between strings and ansistring seems to be messing up the actual bind.
What I had before was this: db.ExecSQL('delete from sqlite_sequence where name=?',[ansistring('Magazines')]); However, when I changed the line to this: db.ExecSQL('delete from sqlite_sequence where name=''Magazines'''); The code did what I needed it to do. On Sat, Feb 10, 2018 at 8:19 PM, Simon Slavin <slav...@bigfraud.org> wrote: > On 11 Feb 2018, at 1:12am, Stephen Chrzanowski <pontia...@gmail.com> > wrote: > > > How does one reset the sqlite_sequence values? > > See section 2.6.2 of > > <https://sqlite.org/fileformat2.html#seqtab> > > When considering how to modify that table, pay attention to the last > paragraph of that section. > > Simon. > _______________________________________________ > sqlite-users mailing list > email@example.com > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users