Hi Again, Thanks for the replies, I'm not sure if it has helped yet (still working on this).
Okay, I have worked out the MapInfo perform a lot of queries to get structures, etc. But the most interesting thing was that the geometry column in the SpatialWare table is passed as a binary string and what is passed over the wire is the same string that lives in the SQL table (SpatialWare doesn't modify the binary string). This suggests that the conversion from MapInfo Object to ST_Spatial BLOB, is either done by MapInfo or it doesn't happen. I have checked this with both SpatialWare 4.6 and 4.8 for SQL Server and they are the same. So my questions now becomes "How do I call the MapInfo conversion routine??" MapInfo can obviously do this on the fly (live tables) with acceptable performance impact. Cheers Ian -----Original Message----- From: Ian Tidy [mailto:[EMAIL PROTECTED] Sent: Thursday, 18 March 2004 3:49 p.m. To: MapInfo-L Subject: MI-L Object Data Type and SpatialWare Geometry Type Hi All, Is there any difference between the SpatialWare Geometry datatype (ST_Spatial) and MapInfo Object datatype. Can I return the SQL server blob object into a MapInfo Object variable?? Cheers Ian Ian Tidy GIS Administrator Works Asset Napier City Council 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. ###################################################################### --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10947
