Do you not have to do a "db.commit" to add the update? I assume the select is to build a recordset.
Regards > > 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. > > 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> > _______________________________________________ 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>
