Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    266

    Unanswered: INSERT DECIMAL in access

    I mamtrying to insert into a access 2000 database a decimal
    and nothing works

    i have tried :

    INSERT INTO MyTable
    (myDecimal) VALUES ('1,1')

    INSERT INTO MyTable
    (myDecimal) VALUES ('1.1')

    INSERT INTO MyTable
    (myDecimal) VALUES (CONVERT(decimal('1,1')))

    INSERT INTO MyTable
    (myDecimal) VALUES (CONVERT(decimal('1.1')))

    INSERT INTO MyTable
    (myDecimal) VALUES (CONVERT(decimal(1,1)))

    INSERT INTO MyTable
    (myDecimal) VALUES (CONVERT(decimal(1.1)))



    thank you for helping

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    Please don't cross post in multiple forums:
    http://www.dbforums.com/showthread.php?t=1609651

    I will look at moving the linked thread here.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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