On Dec 6, 2006, at 12:29 PM, Stefan wrote:
From: Charles Yeomans <[EMAIL PROTECTED]>
Date: 2006/12/05 Tue PM 03:57:39 EST
To: REALbasic NUG <[email protected]>
Subject: transactions in REALSQLDatabase
Suppose I have a REALSQLDatabase transaction having the following
form.
UPDATE
SELECT
UPDATE
COMMIT
Should the SELECT statement see the effect of the UPDATE statement?
It seems like it should.
In general, this relates to the isolation level which is used by
your DB:
http://www.mssqlcity.com/Articles/General/TIL.htm
_______________________________________________
Right. That's why I asked about SQlite in particular. But as I
noted earlier, testing suggests that it behaves as I had expected.
Since I also have to fool with SQL Server, the URL is useful for that
as well.
Charles Yeomans
_______________________________________________
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>
