Results 1 to 2 of 2

Thread: change adColNullable attribute after collumn creation?

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Aug 2000
    Posts
    125
    following is code for setting the adColNullable attribute during column creation, but how do you change it AFTER the column is created?


    Code:
    colTemp.Name = "FaxPhone"
    colTemp.Type = adVarWChar
    colTemp.DefinedSize = 24
    colTemp.Attributes = adColNullable
    
    cat.Tables("Employees").Columns.Append colTemp

  2. #2
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width