PDA

Click to See Complete Forum and Search --> : change adColNullable attribute after collumn creation?


makai
Nov 1st, 2000, 12:38 PM
following is code for setting the adColNullable attribute during column creation, but how do you change it AFTER the column is created?



colTemp.Name = "FaxPhone"
colTemp.Type = adVarWChar
colTemp.DefinedSize = 24
colTemp.Attributes = adColNullable

cat.Tables("Employees").Columns.Append colTemp

JHausmann
Nov 2nd, 2000, 05:33 PM
Assumptions:

Table name(s): Oldtbl, NewTbl

1) Build NewTbl with the structure you want
2) Execute: insert into NewTbl select * from OldTbl
3) Execute: Drop OldTbl
4) Execute: select * from NewTBl insert into OldTbl
5) Execute: Drop NewTbl