Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: pass in null value for boolean data type in VB

    What is the syntax to pass in null value for boolean data type in VB in the stored procedure?

    This is what I tried and it doesn't work.
    .Parameters.Append .CreateParameter("@disposition", adBoolean, adParamInput, 1, vbNull)

    Thank you.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I'm no vb programmer (at least that's what I tell people)

    How about:

    .Parameters.Append .CreateParameter("@disposition", adBoolean, adParamInput, 1, "Null")

    ????
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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