Re: [sqlite] Transactions on attached databases

It's a very useful API, thanks a lot. -- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Dec 12, 2008, at 5:26 PM, D. Richard Hipp wrote: > > On Dec 12, 2008, at 11:16 AM, Marco Bambini wrote: > >> I have two databases, db1 and db2.

Re: [sqlite] Transactions on attached databases

On Dec 12, 2008, at 11:16 AM, Marco Bambini wrote: > I have two databases, db1 and db2. > At some point I attach db2 to db1 as 'destdb' then I do: > > sqlite3_exec(db1, "BEGIN", ...); > sqlite3_exec(db1, "INSERT INTO destdb.table1 SELECT * FROM > main.table1", ...); > sqlite3_exec(db1, "INSERT

[sqlite] Transactions on attached databases

I have two databases, db1 and db2. At some point I attach db2 to db1 as 'destdb' then I do: sqlite3_exec(db1, "BEGIN", ...); sqlite3_exec(db1, "INSERT INTO destdb.table1 SELECT * FROM main.table1", ...); sqlite3_exec(db1, "INSERT INTO destdb.table2 SELECT * FROM main.table2", ...);

[sqlite] Auditing

Hi list, I'd like ideas / recommendations on implementing and auditing to track delta changes to tables. I have about 6 tables in my db with different fields/columns and PK's. My original thought was to have a single audit table for all of them such as audit_delta ( id integer, tab text,

Re: [sqlite] Sqlite3Explorer Sqlite Report Designer

'Tis a bit late of a response, but worth saying. Reports of Delphi's demise have been bandied about for well over a decade. Although it has dropped in market share during that time, it still is a viable and used language. Our firm uses it in one of our key projects because (quite frankly)

Re: [sqlite] Sqlite3Explorer Sqlite Report Designer

*Dear Cariotoglou Mike* I was actually waiting for your reply. Ok, No problem. I can understand the work loads. But keep in mind that your utility will be useful to many of the sqlite-users. If you get time ( after two-three months ) please develop it in such a way that I have discribed in

Re: [sqlite] COMMIT in SQLite

"hussainfarzana" wrote in message news:20971588.p...@talk.nabble.com > We have developed our application in eVC++ 3.0 using SQLite as the > database. While insertion or updation of records > We have used BEGIN and COMMIT method to insert or update the records. > While

[sqlite] COMMIT in SQLite

Hi All, We have developed our application in eVC++ 3.0 using SQLite as the database. While insertion or updation of records We have used BEGIN and COMMIT method to insert or update the records. While running the application we are able to insert and update and we are able to check that value

Re: [sqlite] Sqlite3Explorer Sqlite Report Designer

No I am not in vaccation, I wish! I am rather busy this period, so no, I will not be able to do wthat you wanted, for the next couple of months or so... From: sqlite-users-boun...@sqlite.org on behalf of Rajesh Nair Sent: Thu 11/12/2008 8:55 AM To: General