RE: [MI-L] Spatialware to Well known text

Robert Crossley Fri, 19 May 2006 04:58:46 -0700

Lars,

you are right, this was an error in the question. It was actually sw_geometry that I was trying to filter to get rid of any records that may not have had a spatial object. I did notice this later and tried with SW_GEOMETRY, but it gave the same error anyway.

Exec sp_spatial_query 'Select C_LINKCODE, HG_AsText(SW_GEOMETRY) From dbo.T_AMAL_HARV_OPS where SW_ GEOMETRY IS NOT NULL'

From: Lars I. Nielsen (GisPro) [mailto:[EMAIL PROTECTED]
Sent: 19 May 2006 16:29
To: Robert Crossley
Subject: Re: [MI-L] Spatialware to Well known text

Hi Robert,

Oughtn't sw_member be a primary unique index column, i.e. auto-numbered ? How can it then be NULL, as you test for ??

Best regards / Med venlig hilsen

Lars I. Nielsen

GisPro

Robert Crossley wrote:

Hi all,

I am trying to get a recordset from Spatialware, and extract the geometry object as a well known text or binary. The SQL statement below works well (if a little slow), but while it returns the data, it gives the error message below. Any ideas?

I don’t get it when I run the statement on a table that only contains points. This table only contains polygons.

Exec sp_spatial_query 'Select C_LINKCODE, HG_AsText(SW_GEOMETRY) From dbo.T_AMAL_HARV_OPS where SW_MEMBER IS NOT NULL'

Server: Msg 70201, Level 11, State 1, Line 0

SW-70201: Error from spatial operator: hggeo_ogc_output_wkt_v1

-------------------------------------------

Robert Crossley

Agtrix P/L Australia

Far Southern Queensland Office:

9 Short Street

PO Box 63

New Brighton 2483

P: 61 2 6680 1309

F: 61 2 6680 5214

E: [EMAIL PROTECTED]

W: www.agtrix.com

Brisbane Office:

109 Milsom St

Cooparoo 4151

Queensland

P: 61 7 3843 3363

_______________________________________________

MapInfo-L mailing list

[email protected]

http://www.directionsmag.com/mailman/listinfo/mapinfo-l

_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

RE: [MI-L] Spatialware to Well known text

Reply via email to