Re: [sqlite] Performing Multiple SQL Statements Within A Transactions Using TCL

2013-10-14 Thread Tilsley, Jerry M.
>>-Original Message- >>From: sqlite-users-boun...@sqlite.org >>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gerry Snyder >>Sent: Thursday, October 10, 2013 6:33 PM >>To: General Discussion of SQLite Database >>Subject: Re: [sqlite] Perform

Re: [sqlite] Performing Multiple SQL Statements Within A Transactions Using TCL

2013-10-10 Thread Gerry Snyder
On 10/10/2013 2:14 PM, Tilsley, Jerry M. wrote: All, Does anybody have any examples of wrapping multiple SQL insert/update statements in a transaction using the TCL API? Sure: db transaction { db eval {create table if not exists s2011.tclcode(procname text, version text, tcl text, comm