Ian, My question on how your were retrieving the data was just to make sure you were using the standard way using either linked or live tables.
As to the invalid object. Maybe it is the last node ?? You could try just downloading a single record to see whether this is possible ? eg. "Where MI_PRINX = 5" Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis COWI har fået ny hjemmeside. Ydelserne GIS og IT, kort, kortlægning, 3D visualisering og arealforvaltning ligger under SAMFUND. Se mere her : www.cowi.dk COWI has changed its homepage. Our services within cadastre and landadministration, geodataproducts, mapping and GIS can be seen under SOCIETY. See our services here: www.cowi.com -----Original Message----- From: Ian Tidy [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 5: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 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17655
