Helo

Using ver 2.04b4, I try to alter a table column to not null and I run on
edbmngr

UPDATE MyTable SET FieldId = 1 WHERE FieldId IS NULL
and
ALTER TABLE "MyTable"    ALTER COLUMN "FieldId" AS SMALLINT NOT NULL

the second statement raise a AV error and cause a complete damage on the
table
(I report it on a previous thread with #100 error as subject)

Any suggestion?

Thanks
Sorin

Sorin,

<< Using ver 2.04b4, I try to alter a table column to not null and I run on
edbmngr

UPDATE MyTable SET FieldId = 1 WHERE FieldId IS NULL
and
ALTER TABLE "MyTable"    ALTER COLUMN "FieldId" AS SMALLINT NOT NULL

the second statement raise a AV error and cause a complete damage on the
table  (I report it on a previous thread with #100 error as subject) >>

Please send me the database catalog and table files for your database and
I'll take a look.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

I never fully understand what you expect me to send

The tables with the data or empty? with the data is quite a big size.
To zip it or leave it as it is?

Thanks
Sorin

> Please send me the database catalog and table files for your database and
> I'll take a look.

Sorin,

<< I never fully understand what you expect me to send >>

The database catalog (edbdatabase.edbcat) and the table files (.edbtbl,
..edbidx, .edbblb) for the table that you're altering.  And yes, please .zip
up the files into a single .zip file.

--
Tim Young
Elevate Software
www.elevatesoft.com