ADOX adding columns
Posted on 2000-02-18
I'm very new to ADOX and I'm having some trouble.
I can't work out how to add new columns to a table with certain properties.
Just in case it matters, I'm creating a new Access 97 database.
The only thing I've managed to get to work is something like this:
Set objNewColumn = New ADOX.Column
objNewColumn.Name = "FieldX"
objNewColumn.DefinedSize = 15
objNewColumn.Attributes = adColNullable 'also objNewColumn.Attributes =
1 - When Attributes = adColFixed, it won't allow me to leave the field
blank. If adColNullable, it allows NULL values. I would like to be able to
leave the field blank *without* allowing NULL values. How?
2 - I can't seem to be able to use the Type property. Any time I use it it
throws errors.... How can I make a column numeric this way?