Re: [sqlite] Different kind of constraint

On 02/11/2018 12:34 PM, Stephen Chrzanowski wrote: I've been mucking with this for the last half hour or so. I have a table which is kind of in a unique situation. In the app I was talking about earlier, I have a table that will contain BLOB that has FK data referencing a magazine table. This

Re: [sqlite] Reset value of sqlite_sequence

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

Re: [sqlite] Reset value of sqlite_sequence

Delphi Berlin 10.1 using his SQLite Wrapper from I don't know how long ago. Its served me well in Delphi 7, but with the move to Unicode materials, its got a few things to iron out that I've been able to work around in code. Like this threads sample. :] On Sat, Feb 10, 2018 at 8:51 PM, Simon

Re: [sqlite] Reset value of sqlite_sequence

Half thought... SQLite Wrapper from Tim Anderson at itwriting.com On Sat, Feb 10, 2018 at 9:06 PM, Stephen Chrzanowski wrote: > Delphi Berlin 10.1 using his SQLite Wrapper from I don't know how long > ago. Its served me well in Delphi 7, but with the move to Unicode >

Re: [sqlite] sqlite 3.22.0 read-only WAL mode clarifications

Hey Simon, thanks for your clarification. > Will any of the processes accessing the database have write permission > ? If not, if they're all just reading the existing database, then > there's no opportunity for corruption. Think of it as All of the processes (on "main" and remote host) have

[sqlite] Reset value of sqlite_sequence

How does one reset the sqlite_sequence values? I'm trying with [ delete from sqlite_sequence where name='...' ] but my app continuously goes and keeps adding up the number. If I go into a 3rd party tool and delete the table, the next time my app goes and populates data, the counter starts at 1.

Re: [sqlite] Reset value of sqlite_sequence

On 11 Feb 2018, at 1:12am, Stephen Chrzanowski wrote: > How does one reset the sqlite_sequence values? See section 2.6.2 of When considering how to modify that table, pay attention to the last paragraph of that section.

Re: [sqlite] Different kind of constraint

Is FileType case sensitive? --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski >Sent:

Re: [sqlite] Reset value of sqlite_sequence

On 11 Feb 2018, at 1:39am, Stephen Chrzanowski wrote: > What I had before was this: > db.ExecSQL('delete from sqlite_sequence where > name=?',[ansistring('Magazines')]); Oh dear. Don't you just hate getting lost in multiple text representations ? C++ Builder ? Delphi ?

[sqlite] Different kind of constraint

I've been mucking with this for the last half hour or so. I have a table which is kind of in a unique situation. In the app I was talking about earlier, I have a table that will contain BLOB that has FK data referencing a magazine table. This blob-tables responsibility is going to hold the

Re: [sqlite] sqlite 3.22.0 read-only WAL mode clarifications

On 10 Feb 2018, at 7:07am, Leonard Lausen wrote: > thanks for your clarification. You're welcome. A couple of things you wrote make me think I phrased things poorly so I'm just taking this opportunity to illustrate what I wrote. >> Will any of the processes accessing the