Setting Field To Allow Zero Length Records

[Michael42]

Hello, using ASP 2.5\ADO I can add new fields to my tables with no problem using syntax such as: ALTER TABLE app ADD COLUMN Item CHAR(25).

How can I programatically set the field so as it WILL allow Allow Zero Length Records?

Thanks, Michael

 

[palbano]

Can't remember. Try the one of the SQL forums.

 

[Tarwn]

I believe the NULL keyword may be what you are looking for, either that or it will default to allow nulls and you use NOT NULL to specify you don't want 0 length fields, sorry I couldn't be of more assistance, memory's shot
-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
For my next trick I will pull a hat out of a rabbit (if you think thats bad you should see how the pigeon feels...)

 

[Michael42]

Thanks very much guys! Michael