Bug report #5966

Adding values ​​in a field of type "real" in a MSSQL table

Added by Franck-Yves DABIN about 7 years ago. Updated about 6 years ago.

Status:Closed
Priority:High
Assignee:Tamas Szekeres
Category:Data Provider/MSSQL
Affected QGIS version:1.8.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:15385

Description

Hi,

It seems there be a confusion between scale and size for real fields in Quantum GIS.

For example : When we specify a field in MSSQL of type :
- Decimal
- Size/Precision : 10
- Scale : 2
We can adding values like {xxxxxxxx,xx}

This same field appears in Quantum GIS like :
- Decimal
- Length : 12
- Precision : 10
We can adding values like {xx,xxxxxxxxxx}

Associated revisions

Revision b1efd479
Added by Jürgen Fischer about 6 years ago

- introduce qgsDoubleToString for format double with maximum precision
- usage in mssql provider fixes #7638
- read precision in mssql provider (fixes #5966)
- commit errors are only shown once

History

#1 Updated by Paolo Cavallini about 7 years ago

  • Target version changed from Version 1.8.0 to Version 2.0.0

#2 Updated by Nathan Woodrow over 6 years ago

  • Priority changed from Normal to High
  • Assignee set to Tamas Szekeres

#3 Updated by Jürgen Fischer about 6 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF