Re: [sqlite] Reset value of sqlite_sequence

2018-02-11 Thread R Smith
(Apologies if this is duplicate) On 2018/02/11 3:12 AM, Stephen Chrzanowski wrote: How does one reset the sqlite_sequence values? How about: UPDATE sqlite_sequence SET seq = 1 WHERE name = 'myTable'; ___ sqlite-users mailing list sqlite-users@mail

[sqlite] header intact

2018-02-11 Thread Zhiwen Zheng
___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Different kind of constraint

2018-02-11 Thread Stephen Chrzanowski
Keith> Fixed text pushed by code, no user interaction to define what goes in this field will exist. The FileType handle will be used for different file type descriptors that I'll later be grouping together (IE: JPG, PNG, BMP all become "Images", while MP3 or WAV would be AUDIO). I can set the fie

Re: [sqlite] Reset value of sqlite_sequence

2018-02-11 Thread Stephen Chrzanowski
Thanks Ryan. The problem I had was with the string "myTable" when I was doing a Delete. My wrapper isn't 100% Unicode friendly apparently, and I had to do a minor and easy work around. Even SQLite Expert wasn't returning what I wanted from a select, so I eventually determined my insert statement

Re: [sqlite] Reset value of sqlite_sequence

2018-02-11 Thread R Smith
On 2018/02/11 3:12 AM, Stephen Chrzanowski wrote: How does one reset the sqlite_sequence values? How about: UPDATE sqlite_sequence SET seq = 1 WHERE name = 'myTable'; ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailingli

Re: [sqlite] Different kind of constraint

2018-02-11 Thread J Decker
Just a thought; a thumbnail/cover image seems like somehting that is often gotten before lots of other data, and maybe storing that alone in a table of covers would keep that index shorter for the entry pages... And then you could enforce unique parent id on the cover and not on the content. On Su

Re: [sqlite] Different kind of constraint

2018-02-11 Thread Stephen Chrzanowski
That is perfectly valid, and would resolve a bunch of other headaches. I think I'll go that route. Thanks. On Sun, Feb 11, 2018 at 8:47 AM, J Decker wrote: > Just a thought; a thumbnail/cover image seems like somehting that is often > gotten before lots of other data, and maybe storing that al

[sqlite] sqlite session extension and conflict rollback

2018-02-11 Thread perditionc
Hello everyone, Does anyone know of any additional documentation or good examples of the session extension usage? I am probably using it in an odd way, but I encountered something that makes perfect sense but was surprising originally. Basically if you use the session extension and apply a chang