Maybe the string length is too big for MI to cope with? Some errors are "referred" and aren't what the problem actually is.
As a test, can you break it down into something shorter? Chop off some decimal points, perhaps - and drop off a couple of points. --- Ian Thomas GeoSciSoft - Perth, Australia -----Original Message----- From: Ian Tidy [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 11:48 AM To: MapInfo-L Subject: RE: MI-L MapInfo and SpatialWare Error... Thanks to those who have replied. I am still looking for a solution. I have managed to locate an Invalid Geometry: ST_Spatial( ST_Polygon( ST_Path( ST_Polyline( LIST{ ST_Point(175.367368566700,-37.837910000000), ST_Point(175.367368550000,-37.837910083300), ST_Point(175.367895300000,-37.838427183300), ST_Point(175.368299583300,-37.838809300000), ST_Point(175.369155216700,-37.839558983300), ST_Point(175.369155250000,-37.839558900000), ST_Point(175.368299683300,-37.838809283300), ST_Point(175.367895383300,-37.838427183300), ST_Point(175.367368566700,-37.837910000000) } ) ) ), ST_Point(175.368283440757,-37.838793932631) ) SpatialWare considers this valid, but MapInfo doesn't can anyone tell me why?? Cheers Ian -----Original Message----- From: Ian Tidy [mailto:[EMAIL PROTECTED] Sent: Monday, 29 August 2005 2:06 p.m. To: MapInfo-L Subject: MI-L MapInfo and SpatialWare Error... Hi All, I keep getting the following error: "Cannot insert an empty object into a table or layout. Unable to refresh linked table." I am trying to download data from a query in SQL Server. I have checked for NULL in the SW_GEOMETRY and HG_Is_Invalid returns 0 records, so all my geometries must be valid. I have renamed the SW_MEMBER to MI_PRINX in the query. Any ideas?? TIA Cheers Ian Ian Tidy GIS Administrator Works Asset Department Napier City Council Hastings St, Private Bag 6010, Napier, New Zealand Phone +64-6-835-7579 Ext. 8115 Fax +64-6-835-7574 mailto:[EMAIL PROTECTED] http://www.napier.govt.nz ###################################################################### Attention: This e-mail message and accompanying data may contain information that is confidential and subject to legal privilege. Any information provided is given in good faith. However unless specifically stated to the contrary, Napier City Council accepts no liability for the content of this e-mail or for the consequences of any action taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this e-mail message in error, please notify us immediately and erase all copies of this message and attachments. Thank you. ###################################################################### This e-mail message has been scanned and cleared by MailMarshal ###################################################################### ###################################################################### Attention: This e-mail message and accompanying data may contain information that is confidential and subject to legal privilege. Any information provided is given in good faith. However unless specifically stated to the contrary, Napier City Council accepts no liability for the content of this e-mail or for the consequences of any action taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this e-mail message in error, please notify us immediately and erase all copies of this message and attachments. Thank you. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17654 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.17/84 - Release Date: 29/08/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.17/84 - Release Date: 29/08/2005 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17663
