Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Valley City, OH
    Posts
    18

    Unanswered: Decimal DataType

    Good Morning

    Shopping for a bit of assistance with the decimal datatype in a SQL Server 7.0 database. I am sending data with 2 decimal places from a
    VB6 program to the databse table and the decimal positions are getting cut-off. IE .10 is turning into 0. I have the field in my databse table
    defined as decimal, 5 long and a precision of 2. Any ideas what I am doing wrong?

    Thanks for the help,
    EJD

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How is the vb veriable defined?
    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.

  3. #3
    Join Date
    Oct 2003
    Location
    Valley City, OH
    Posts
    18
    CDec(cobjCustomRS("CustomNumber"))

Posting Permissions

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