Re: [sqlite] Problem with Foreign Key constraints

2012-10-02 Thread Duquette, William H (318K)
On 10/1/12 1:32 PM, "Duquette, William H (318K)" wrote: >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 snapsh

Re: [sqlite] Problem with Foreign Key constraints

2012-10-01 Thread Duquette, William H (318K)
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 t

Re: [sqlite] Problem with Foreign Key constraints

2012-10-01 Thread Black, Michael (IS)
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 Grumm