"Tom Briggs" <[EMAIL PROTECTED]> wrote: > The insert will not be allowed until the query is closed, so you > can't get into this situation. >
This used to be the case. But as of version 3.3.8, you can in fact issue an UPDATE, INSERT, or DELETE against a table while a SELECT is running on that same table. This change was introduced unannounced in version 3.3.8. So many long-time users (such as Tom) don't know about it. Yes, I know, I should do a better job of announcing important changes like this. I stand rebuked. I'll try to do better.... -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------