mibuso.com
Home› SQL General
Options

Decimal Format in SQL Server

steallosteallo Member Posts: 21
edited 2008-04-02 in SQL General
Hi all why in sql i have decimal fields lenght 38 with 20 decimal part?
Because if i try to use driver Jet 4.0 SP8 (MS ACCESS ODBC DRIVER) this decimal fields are reads like text and not like decimal!
Thx in advance
Best Regards
Stefano Cominotti

Comments

  • Options
    bbrownbbrown Member Posts: 3,268
    Access supports a maximum decimal precision of 28 digits. SQL allows 38 which is the setting used by Navision. Any decimal field with a precision higher than 28 then Access will treat it as text.

    Possible Solution


    Create a view that formats the decimal fields with a precision that Access can support.


    Example: (This is from a non-Navision database)


    SELECT [ID] ,CONVERT(Decimal(28,10),[Amt]) As Amount
    FROM [Test].[dbo].[Check]
    There are no bugs - only undocumented features.
  • Options
    steallosteallo Member Posts: 21
    ](*,) ](*,) ](*,) ](*,) ](*,) ](*,)

    ok but i have to do this for all the tables that i need and are not few!!!!other possible solution???? [-o<
  • Options
    shunkskillshunkskill Member Posts: 2
    Hi all - i've got the same Prob with Access!

    Other Solutions known???

    Greetings

    Shunkskill :
  • Options
    bbrownbbrown Member Posts: 3,268
    I have not found any.

    There are reasons why Access is a fraction of the cost of SQL.

    :)
    There are no bugs - only undocumented features.
  • Options
    shunkskillshunkskill Member Posts: 2
    Ok, accepted:)
    But...does it give a tool as simply as ACCESS, however the data types recognizes correctly?

    Best Regards
    Shunkskill
Sign In or Register to comment.