Re: [sqlite] Problem with Foreign Key constraints

Actually, I'm using the Tcl interface, so I'm using whatever the Tcl interface uses. I've now verified that within the transaction I can take a snapshot, put it back using the new method, and retrieve a new snapshot, and that these snapshots are identical. But when I close the transaction using

Re: [sqlite] Problem with Foreign Key constraints

You don't show any code but it sounds like you're using volatile variables. Are you using SQLITE_STATIC instead of SQLITE_TRANSIENT? http://www.sqlite.org/c3ref/bind_blob.html Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop

[sqlite] Problem with Foreign Key constraints

Howdy! I have some code that does the following: 1. Takes a snapshot of some number of database tables, e.g., saves the data from those tables as a text string. 2. Later, clears the tables and restores their content from the snapshot. The snapshot is restored by creating a new INSERT statement

Re: [sqlite] how to open a tickect with an issue?

Unfortunately, tickets cannot be submitted anonymously, due to spammers. However, I will try to help if you post a description of the problem, along with details, to this mailing list. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] Problems in VFS file read

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 30/09/12 19:16, Roger Binns wrote: > Looking through the code for both VFS I don't see any attempt to check > the amount parameter is positive, and in both cases it silently gets > passed to a routine expecting unsigned (size_t or DWORD).

Re: [sqlite] sqlite + EF4 + 'on cascade delete' = not working

I found out recently that sometimes on a per-session basis, you have to turn the foreign key check on. So even though one provider has it on by default, another may not. http://www.sqlite.org/pragma.html#pragma_foreign_keys I had a SQLite3 Database manager running, and the SQL to delete a row

Re: [sqlite] how to open a tickect with an issue?

See http://www.sqlite.org/src/wiki?name=Bug+Reports . Pavel On Mon, Oct 1, 2012 at 3:10 AM, Álvaro García wrote: > I Have a problem with Entity framework and SQLite and I would like to open a > ticket to expose my problem, but I don't see the way to open the ticket. > >

Re: [sqlite] Store error messages in thread local memory

As a side note: I've compiled some performance data and published them as an article on my blog: http://manski.net/2012/10/01/sqlite-performance/ Do these result seem to be ok? - Sebastian On Mon, Sep 24, 2012 at 5:02 PM, Olaf Schmidt wrote: > Am 24.09.2012 11:26, schrieb

Re: [sqlite] Issue with SQLite3 for WinRT ARM

I took a wee bit of a look at your project -- don't have Win 8 so can't debug it. And you didn't include the sqlite assembly anyways. But...if I read your comments correctly it appears that the primary difference between what works and what doesn't is the size of the SQL string. So...this

Re: [sqlite] sqlite + EF4 + 'on cascade delete' = not working

David Richardson wrote: > I’m having some sort of bug with system.data.sqlite. > when I try to delete it should cascade , but 'on cascade delete’ does NOT > work. In SQLite, it's called "on delete cascade": sqlite> pragma foreign_keys=on; sqlite> create table parent(id integer primary key);

[sqlite] how to open a tickect with an issue?

I Have a problem with Entity framework and SQLite and I would like to open a ticket to expose my problem, but I don't see the way to open the ticket. could someone help me? Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] sqlite + EF4 + 'on cascade delete' = not working

Hi community   I’m having some sort of bug with system.data.sqlite. I’ve been trying for weeks now!  I’ve installed (System.Data.SQLite 1.0.81.0) and i’m using sqlite in combination with Entity Framework 4. Mostly it does what I want. The only problem I’m having is that when I try to delete it