Howdy,
I'm having problems writing Spatialware SQL involving a table (heritage) that holds data for a point object (X & Y).
Shows in the Spatialware MapCatalog as having a SPATIALTYPE of 4 ( which I assume means that while this table exists in Spatialware with an sw_geometry field - it doesn't have an sw_member field and is not a true Spatialware table ?)
I receive errors whenever using this field in any Spatialware functions eg
EXEC sp_spatial_query
'SELECT p.sw_member
FROM Property p,heritage h
WHERE ST_CONTAINS(p.sw_geometry,h.sw_geometry)'
SW-70204: Incorrect parameter type for spatial operator in column_verify.....
I attempted to get round this by using ST_Point as per below, but this query seems to hang (no result after 20 mins)
EXEC sp_spatial_query
'SELECT p.sw_member into heritage_temp1
FROM heritage h,Property p
WHERE ST_CONTAINS(p.sw_geometry,ST_Point(h.x,h.y))'
Can anyone shed any light on what to do to get around this problem ?
Cheers
John Gosbell
CITY OF BURNSIDE
* 401 Greenhill Road TUSMORE SA 5065
(+61 8 8366 4130 0434 404 86 0
2 +61 8 8366 4200
, [EMAIL PROTECTED]
: www.burnside.sa.gov.au
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
