Professional Web Applications Themes

Adding a NULL Value in a Currency table in an Access DB - ASP Database

Hello there, I have a problem with Adding a NULL Value in a Currency table in an Access database. The problem accurs when i'm trying to Update an empty field. The error message is: Error Type: Provider (0x80020005) Type mismatch. /travel/update_delete_datprijs.asp, line 43 Can some one help me with a solution? Thanks in advance....

  1. #1

    Default Adding a NULL Value in a Currency table in an Access DB

    Hello there,

    I have a problem with Adding a NULL Value in a Currency table in an Access
    database. The problem accurs when i'm trying to Update an empty field. The
    error message is:

    Error Type:
    Provider (0x80020005)
    Type mismatch.
    /travel/update_delete_datprijs.asp, line 43


    Can some one help me with a solution?

    Thanks in advance.


    Raven Guest

  2. #2

    Default Re: Adding a NULL Value in a Currency table in an Access DB

    Raven wrote:
    > Hello there,
    >
    > I have a problem with Adding a NULL Value in a Currency table in an
    > Access database. The problem accurs when i'm trying to Update an
    > empty field. The error message is:
    >
    > Error Type:
    > Provider (0x80020005)
    > Type mismatch.
    > /travel/update_delete_datprijs.asp, line 43
    >
    >
    > Can some one help me with a solution?
    >
    > Thanks in advance.
    This always seems to work for me:
    update table set [moneyfield] = Null

    Bob Barrows



    Bob Barrows Guest

  3. #3

    Default Re: Adding a NULL Value in a Currency table in an Access DB

    Raven wrote:
    > Hello there,
    >
    > I have a problem with Adding a NULL Value in a Currency table in an
    > Access database. The problem accurs when i'm trying to Update an
    > empty field. The error message is:
    >
    > Error Type:
    > Provider (0x80020005)
    > Type mismatch.
    > /travel/update_delete_datprijs.asp, line 43
    >
    >
    > Can some one help me with a solution?
    >
    > Thanks in advance.
    Please do not multipost. i've already answered this question over in
    ..asp.db.


    Bob Barrows Guest

  4. #4

    Default Re: Adding a NULL Value in a Currency table in an Access DB

    a currency cant be null dont add null add 0.00 or 0 instead. Try it
    "Raven" <raviramtiscali.nl> wrote in message
    news:bfgctc$pvc$1reader1.tiscali.nl...
    > Hello there,
    >
    > I have a problem with Adding a NULL Value in a Currency table in an Access
    > database. The problem accurs when i'm trying to Update an empty field. The
    > error message is:
    >
    > Error Type:
    > Provider (0x80020005)
    > Type mismatch.
    > /travel/update_delete_datprijs.asp, line 43
    >
    >
    > Can some one help me with a solution?
    >
    > Thanks in advance.
    >
    >

    Ronnie Patton Guest

  5. #5

    Default Re: Adding a NULL Value in a Currency table in an Access DB

    Hello Bob,

    Thank you for your support, it's working.

    Raven

    "Bob Barrows" <reb_01501> wrote in message
    news:%23HRA4k3TDHA.1868TK2MSFTNGP11.phx.gbl...
    > Raven wrote:
    > > Hello there,
    > >
    > > I have a problem with Adding a NULL Value in a Currency table in an
    > > Access database. The problem accurs when i'm trying to Update an
    > > empty field. The error message is:
    > >
    > > Error Type:
    > > Provider (0x80020005)
    > > Type mismatch.
    > > /travel/update_delete_datprijs.asp, line 43
    > >
    > >
    > > Can some one help me with a solution?
    > >
    > > Thanks in advance.
    >
    > This always seems to work for me:
    > update table set [moneyfield] = Null
    >
    > Bob Barrows
    >
    >
    >

    Raven Guest

  6. #6

    Default Re: Adding a NULL Value in a Currency table in an Access DB

    The problem is solved.

    "Ronnie Patton" <someonemicrosoft.com> wrote in message
    news:s4RSa.8271$ii2.817fe2.columbus.rr.com...
    > a currency cant be null dont add null add 0.00 or 0 instead. Try it
    > "Raven" <raviramtiscali.nl> wrote in message
    > news:bfgctc$pvc$1reader1.tiscali.nl...
    > > Hello there,
    > >
    > > I have a problem with Adding a NULL Value in a Currency table in an
    Access
    > > database. The problem accurs when i'm trying to Update an empty field.
    The
    > > error message is:
    > >
    > > Error Type:
    > > Provider (0x80020005)
    > > Type mismatch.
    > > /travel/update_delete_datprijs.asp, line 43
    > >
    > >
    > > Can some one help me with a solution?
    > >
    > > Thanks in advance.
    > >
    > >
    >
    >

    Raven Guest

Similar Threads

  1. Question Currency format null when = 0
    By Lulu in forum Brainstorming Area
    Replies: 0
    Last Post: November 17th, 09:49 PM
  2. Adding UNIQUE constraint on NULL column
    By Dave Smith in forum PostgreSQL / PGSQL
    Replies: 6
    Last Post: January 13th, 09:39 PM
  3. Replies: 1
    Last Post: August 10th, 12:41 PM
  4. help. null dynamic table results in error
    By stewboy webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 2
    Last Post: July 22nd, 07:43 PM
  5. Finding null values in a large table
    By Tim Dry in forum Oracle Server
    Replies: 5
    Last Post: December 6th, 10:53 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