Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    immission required for all fileds!!!! (2000)

    I have created with adox a new table and fileds...
    But the table alreday created all fields have the property REQUIRED!!!!!
    How to set the filed not reired for entry????
    i use this line:

    .Columns.Append "PROVA" & X, adVarWChar, 100

    peraphs i can use an additional param during the creation for each filed???
    See image

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: immission required for all fileds!!!! (2000)

    Hi there

    Have you tried something similar to:
    <pre> .Columns.Append (PROVA) & X, adVarWChar, 100
    With DBtable.Columns.Item(PROVA)
    Set .ParentCatalog = DBcatalogue
    .Properties("Jet OLEDB:Allow Zero Length") = True
    .Properties("Nullable") = True
    End With
    </pre>

    Jerry

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: immission required for all fileds!!!! (2000)

    Good!
    Tks a lot...

Posting Permissions

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