Upgraded to SQL Server version and column precision has changed.

Moving from the Progress DB to SQL Server version discount percentage type columns are decimal(7,3) but in the old version it is decimal(8,3). Also a lot of other decimal columns went from (16,6) to (15,6).

How have people handled this? It is breaking some of our procedures.


Parents Reply
  • 0 in reply to Dwight

    Recently I noticed an issue with decimal UDF's that use a numeric mask... where the numeric format in SQL changes depending on whether the mask has the "-" at the beginning or the end.

    (Numeric mask does not affect the technical data structure in Providex, but it does in SQL).

No Data