Just back from the London Boat Show - happy new year everyone and well
done Tim giving a firm date for EDB!

I have been re-working my soon-to-be-released database with Context
Database Designer, and made the mistake of adding a group of NOT NULL
fields to an already-populated table without giving a default value.

Context DBDesigner (quite correctly) supplied the following piece of SQL:

ALTER TABLE "Locations"
 ADD "locAcc1" CHAR(4) AT 17 NOT NULL,
 ADD "locAcc2" CHAR(4) AT 18 NOT NULL,
 ADD "locAcc3" CHAR(4) AT 19 NOT NULL,
 ADD "locAcc4" CHAR(4) AT 20 NOT NULL;

but when run this gives the rather inappropriate error:

DBISAM Engine Error # 9494 Too many BLOBs opened in table ‘54280’.

I've added  DEFAULT '_' after NOT NULL and all is well, but it's perhaps
worth trying to make the error message a little clearer?

--
Chris
(XP-Pro + Delphi 7 Architect + DBISAM 4.24 Build 1)

Chris,

<< but when run this gives the rather inappropriate error:

DBISAM Engine Error # 9494 Too many BLOBs opened in table '54280'.

I've added  DEFAULT '_' after NOT NULL and all is well, but it's perhaps
worth trying to make the error message a little clearer? >>

Actually, this is an error in the ALTER TABLE.  A fix will be in the next
build.

--
Tim Young
Elevate Software
www.elevatesoft.com