Re: UPDATE and ALTER in transactions do not mix


Jamie Collins wrote:
> > Can anyone verify that UPDATE followed by an ALTER statement, inside of a
> > transaction, would cause the "table in use by another user" error

I just re-read this! My re-test:

m_Conn.Open
m_Conn.BeginTrans
m_Conn.Execute "UPDATE Test SET earnings_amt = 12"
m_Conn.Execute "ALTER TABLE Test ADD blah INTEGER"
-- error: "The database engine could not lock table 'Test' because it
is already in use by another person or process."

.

Loading