-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Mime-Version: 1.0 Content-Type: multipart/mixed; x-avg-checked=avg-ok-786B32B5; boundary="=======176C28DF======="
- --=======176C28DF======= Content-Type: text/plain; x-avg-checked=avg-ok-786B32B5; charset=us-ascii; format=flowed Content-Transfer-Encoding: 8bit I work via sqlite3_prepare and submit this transaction at once... What I now saw is that prepare only parses 1 action ... Is that correct? At 12:51 3/12/2004, you wrote: >Steven Van Ingelgem wrote: >>Hi, >>I do the following (SQLite 308 from C++ source in windows): >>BEGIN DEFERRED TRANSACTION;DELETE FROM Inbox;INSERT...;COMMIT >>TRANSACTION; END TRANSACTION; >>Now, nothing is done? Nothing inserted, nothing deleted from Inbox... > >Probably you are encountering an error which is causing the >transaction to roll back. Check your return codes. > >COMMIT ends the transaction. The END is redundant. > > >-- >D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 > > > > - --=======176C28DF=======-- -----BEGIN PGP SIGNATURE----- Version: PGP 8.0.3 iQA/AwUBQbBpE8pHmxag5XckEQJjogCZAcJxdn/xqZ2BGkIdrkjGLyDmrO4AoPT9 Yom25cqVcvtGZ3aUDvX2WP0H =Qdrd -----END PGP SIGNATURE-----
