Hi, What version of SpatialWare are you running? There are some new functions in 4.8 that might help.
But this will work: exec sp_spatial_query ' select hg_bounding_box(sw_geometry) As MBR into temp from dbo.parcel' exec sp_spatial_query ' select hg_getstring(MBR) As MER from temp' drop table temp The problem seems to be that hg_bounding_box is a grouping function and hg_getstring isn't, this combined with the way SpatialWare processes queries is causing the problem. Cheers Ian Ian Tidy GIS Administrator Works Asset Napier City Council mailto:[EMAIL PROTECTED] http://www.napier.govt.nz -----Original Message----- From: �????? ????? [mailto:[EMAIL PROTECTED] Sent: Thursday, 18 March 2004 2:57 a.m. To: [EMAIL PROTECTED] Subject: MI-L how can I get coordinates of hg_bounding_box (SpatialWare) Hello, I try to get MBR (or MER) of all geometries in a table. Following to UserGuide of Spatialware I write sp_spatial_query 'select hg_bounding_box(sw_geometry) from mytestcon' and it works but I get some binary object. Now I would like to know coordinates of this object. How? I tried sp_spatial_query 'select HG_GetString(hg_bounding_box(sw_geometry)) from mytestcon' but it is finished by a message: SW-70901: Syntax error detected at line 471: syntax error at 'hg_bounding_box'. Waiting for help Evgeny ###################################################################### 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: 10921
