You can't use REAL field type for ID as it a bit approximately, e.g.,
number '1234567890123456789' will memorised as '1,23456789012347E+018'.
The INTEGER should be used instead. You have already hit the limitations
for INTEGER as only 4 bytes are used (-2147483648 .. 2147483647).
Best regards,
Karlis
Christine wrote:
We also had a problem these days with a shapefile in QGIS. A field of this
shapefile was defined with REAL; length 19 and precision 0, just at the
limits Zirneklitis wrote about [On Apr 20, 2012, at 2:29 AM]:
........
It's against SHP specification. The maximum precision of number field is
18 (with scale> 0, scale max = 17) or 19 (with scale = 0 ).
........
The field contained an object_id. An attempt to save/export selected
features of the shapefile let all the object_id fields be filled with
-2147483648 values.
..
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
