On Jan 18, 2007, at 8:43 PM, [EMAIL PROTECTED] wrote:
Hi, all!
With all the talk about putting an begin-transaction
command at the start of REALSQLDatabase transactions,
may I ask whether or not an end-transaction command
is also needed? If so, where does it belong? I imagine
the sequence is something like the following.
App.CatalogDB.SQLSelect("begin transation")
...
App.CatalogDB.InsertRecord "Patrons", newbie
if error <> 0 then
App.CatalogDB.Commit
else
app.catalog.rollback
MsgBox "There's a mistake in adding this record!"
end if
Begin transaction is ended by committing or rolling back
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
