I made the mistake of doing this:

START TRANSACTION WITH sometable;
ALTER sometable
ADD COLUMN if not exists "somecolumn" date;
COMMIT FLUSH

This causes a 11279 access violation in a query c/s 4.23b and in dbsys (both c/s and
local). This error shows up in the server log.

Since transactions are incompatible with alter, I would remove the transaction in the future.

Tim, is this a minor incident report, old news, what?

Dave M.

Dave,

<< I made the mistake of doing this:

START TRANSACTION WITH sometable;
ALTER sometable
ADD COLUMN if not exists "somecolumn" date;
COMMIT FLUSH

This causes a 11279 access violation in a query c/s 4.23b and in dbsys
(both c/s and local). This error shows up in the server log. >>

It's a bug with the restricted transactions and ALTER TABLE.  The ALTER
TABLE should just cause the transaction to commit automatically:

http://www.elevatesoft.com/dbisam4d5_transactions.htm

"Incompatible Operations"

--
Tim Young
Elevate Software
www.elevatesoft.com