Professional Web Applications Themes

Any way to set NULLvalue using DB-Library? - Microsoft SQL / MS SQL Server

Hi: We are using DB-Library C to insert data into SQL2K. Is there any way to insert NULL value? We are now using bcp_bind, bcp_sendrows. Thanks Sidney Zhang...

  1. #1

    Default Any way to set NULLvalue using DB-Library?

    Hi:
    We are using DB-Library C to insert data into SQL2K.
    Is there any way to insert NULL value? We are now using bcp_bind,
    bcp_sendrows.

    Thanks
    Sidney Zhang


    Sidney Zhang Guest

  2. #2

    Default Re: Any way to set NULLvalue using DB-Library?

    [posted and mailed, please reply in public]

    Sidney Zhang (sidneyzneonetech.com) writes:
    > We are using DB-Library C to insert data into SQL2K.
    > Is there any way to insert NULL value? We are now using bcp_bind,
    > bcp_sendrows.
    First, if you are writing a new application, consider switching to
    use ODBC or OLE DB. Microsoft stopped developing DB-Library many
    years ago, and with DB-Library you don't have access to all features
    in SQL Server. Both ODBC and OLE DB have bulk-copy interfaces too.

    Yes, it is possible to send a NULL value. Looking at some code I have
    a round it seems that if I in the call to bcp_bind have specified
    SQLCHAR as the the type and then set that bound variable to point at
    an empty string, I get a NULL value in the database.

    You may be using bcp_bind differently. A code sample would help for a
    more accurate answer.


    --
    Erland Sommarskog, SQL Server MVP, [email]sommaralgonet.se[/email]

    Books Online for SQL Server SP3 at
    [url]http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp[/url]
    Erland Sommarskog Guest

Similar Threads

  1. http, library loaded, httpS library can't be found
    By DeadWisdom in forum PERL Modules
    Replies: 0
    Last Post: November 8th, 04:51 PM
  2. Replies: 39
    Last Post: October 14th, 02:50 PM
  3. Replies: 1
    Last Post: August 18th, 10:51 PM
  4. ~/Library/ vs ~/System/Library vs /User/Library/
    By Doug Brown in forum Mac Applications & Software
    Replies: 8
    Last Post: July 20th, 11:56 PM
  5. Replies: 0
    Last Post: July 9th, 07:42 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139