Showing results for 
Search instead for 
Do you mean 

How to change precision of data values in database records

by Technical Evangelist on ‎03-10-2016 12:09 PM - edited on ‎04-06-2016 01:48 PM by Moderator (327 Views)

Question

 

User has shape files with attribute values stored with 11 decimal places (precision).  When GeoMedia queries are created for these shape files the resulting records have 11 decimal places (precision) which the user doesn't want.  The user wants 2 decimal precision.

There are 2 functional attributes which can be used to create 2 decimal place precision query results.  The "ROUND" and "T RUNC" (Truncate) functional attributes can do this.

Answer

For an example of the "ROUND" and "TRUNC" functional attributes syntax see below.round_trunk_ex.JPG

Contributors