Results 1 to 4 of 4

Thread: Currency type

  1. Aug 30th, 2002, 10:41 AM #1
    seh
    seh is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2002
    Location
    Coventry, England
    Posts
    169

    Currency type

    I'm trying to insert into a sql server db. One of the fields in the sql server db is of currency type. The variable that contains the data to be saved to the sql db is of currency type also. However, I get a Type mismatch, when I execute the sql code. I'm using ADO.

    Thanks.
    Reply With Quote Reply With Quote
  2. Aug 30th, 2002, 12:43 PM #2
    Memnoch1207
    Memnoch1207 is offline
    Frenzied Member Memnoch1207's Avatar
    Join Date
    Feb 2002
    Location
    DUH, Guess...Hint: It's really hot!
    Posts
    1,861
    post your code
    Being educated does not make you intelligent.

    Need a weekend getaway??? Come Visit
    Reply With Quote Reply With Quote
  3. Aug 30th, 2002, 03:19 PM #3
    James Stanich
    James Stanich is offline
    PowerPoster
    Join Date
    Aug 2000
    Location
    IN SILENCE
    Posts
    6,441

    Well

    Are you sure you not trying to insert a NULL value?
    Remaining quiet down here !!!

    BRAD HAS GIVEN ME THE ULTIMATIVE. I have chosen to stay....
    Reply With Quote Reply With Quote
  4. Aug 31st, 2002, 05:15 AM #4
    seh
    seh is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2002
    Location
    Coventry, England
    Posts
    169
    Doh, I was doing something really stupid. I must have been half asleep. I'll look into it more next time before I decide to post!

    Thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width