On Wed, Jan 2, 2013 at 7:01 PM, Art Heimsoth <artst...@artheimsoth.com>wrote:
> Perhaps, but I think autoCommit is the default with ooSQLite and
> so far I have not found the syntax for Rollback or Commit to
> try that - are they implemented in ooSQLite?
Art,
Yes COMMIT and ROLLBACK are implemented in ooSQLite. (Actually there is
nothing specific to implement.) Here is some utility code I wrote for the
two. It should give you the idea of how to explicitly use COMMIT or
ROLLBACK:
::method commitTransaction private
expose dbConn
sql = 'COMMIT;'
ret = dbConn~exec(sql, .false)
if ret \== dbConn~OK then do
self~reportExecError(sql, .false)
return .false
end
return .true
::method rollbackTransaction private
expose dbConn
sql = 'ROLLBACK;'
ret = dbConn~exec(sql, .false)
if ret \== dbConn~OK then do
self~reportExecError(sql, .false)
return .false
end
return .true
--
Mark Miesfeld
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
_______________________________________________
Oorexx-users mailing list
Oorexx-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oorexx-users
