Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Merge two tables

Discussion in 'Information Technology' started by Andreas, Jul 28, 2006.

Tags:
  1. Andreas

    Andreas
    Expand Collapse
    Guest

    I want to create a new question (óne of those questions with a green cross,
    "query di accodamento" in Italian") to be able to merge some dat from two
    different tables. This works fine as long as I do not want to merge the field
    called "colli". Then Access tells me (In italian so I try to translate) "The
    precision in the decimal field is to small to be able to accept the numerous
    value you tried to add"

    What do I have to do to continue?

    /Andreas
     
  2. Loading...


  3. Jamie Collins

    Jamie Collins
    Expand Collapse
    Guest

    Andreas wrote:
    > Access tells me (In italian so I try to translate) "The
    > precision in the decimal field is to small to be able to accept the numerous
    > value you tried to add"
    >
    > What do I have to do to continue?


    Increase its precision?

    To recreate the problem:

    CREATE TABLE Test1 (
    dec_col DECIMAL(4, 2) NOT NULL
    );

    INSERT INTO Test1 (dec_col)
    VALUES (100);

    -- fails with the error, 'The decimal field's precision is too small to
    accept the numeric you attempted to add.'

    With a scale of 2, the precision would have to be at least 5 to
    accommodate the value 100 i.e. alter to DECIMAL(5, 2).

    Jamie.

    --
     

Share This Page