Re: Help with ALTER TABLE statement

Allen Browne wrote:

Replace:
Number
with:
LONG
to get the Long Integer size.

Required will default to No.

The field's Format property cannot be set with a DDL query statement. You
must use DAO code to set the Format of the Field in the TableDef. However,
since you only want General Number, and the Long cannot contain fractional
values anyway, this seems irrelevant (unless it was just an example.)

To set the Indexed property, execute another DDL query statement, using
CREATE INDEX.


Allen,
Is there a reason for using a Create Index query, instead of
a CONSTRAINT clause in the ALTER TABLE query.

Robert,
As for the Format property, I think it's irrelevant in any
situation. All it does is format the table's *** view,
which should never be displayed to users, so who cares what
it looks like.

--
Marsh
MVP [MS Access]
.

Loading