Please check the following by empirical testing, my memory is not so great. . .
> I've always assumed that COUNT = INSERT (in a WHERE clause) is only valid > immediately after the user performs an insert. > Question #1 is "How long is that valid?" I believe that R:Base will remember the last inserted row for each table for the remainder of the session, or until you disconnect the database. > Question #2 is "What happens to COUNT = INSERT when the user inserts a row > into table A, inserts a row into table B, then checks the COUNT = INSERT on > table A?" It should still work correctly, assuming you did not disconnect the database in the meantime. > Question #3 is "What should COUNT = INSERT return if the user HAS NOT > inserted a row?" (It appears to return the last row in the table. Should > this be valid?) I believe this is undefined behavior -- I think you _do_ get a row, but which one it is I have no idea. -- Larry
