Hi, I am trying to update a large point table. Ideally I want 3D point objects in SpatialWare. I am using SpatialWare 4.8 for SQL Server.
When I try: update test_data set sw_geometry = dbo.ST_Point(X_coord, Y_coord, Z_coord) I get: Server: Msg 8144, Level 16, State 2, Line 1 Procedure or function dbo.ST_Point has too many arguments specified. And when I tried: update test_data set sw_geometry = dbo.ST_Point(X_coord, Y_coord) I got: Server: Msg 8626, Level 16, State 1, Line 1 Only text pointers are allowed in work tables, never text, ntext, or image columns. The query processor produced a query plan that required a text, ntext, or image column in a work table. My X_coord, Y_coord, Z_coord, columns are all float data types. I have done this before without any problems on another machine. Please help. 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.
