Hi, I have a 1 Gb db in oracle and manupulate it in MI. I recently discovered an issue that I haven't been able to resolve. The layers consist mostly of very large region polygon sets. The regions are very complex and extend over thousands of miles. Each region may consist of one or more separate polygons. The maps are stored in Lat/Long. In MI I do an SQL "point in poly" query and get a result of 4041. At the Oracle SQL command line, I do the identical query (different command syntax, but same meaning) and get a result of 4043. After doing some extensive testing, I determined that oracle was using the full stored precision to do the calculations and MI was rounding to 0.001. Because of the large sizes of individual objects and as data is stored in Lat/Long, I need 0.000001 places of accuracy to get realistic answers. The data was entered by coordinates. When you select them in MI and get info, it displays the full coordinates. My ezldr upload to oracle sent the all coords with full precision. does anyone know if there is a way to change MI's precision for built in functions (ie: SQL QUERY)??? Thanks for you assistance. Martin Rothman [EMAIL PROTECTED] ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
