Hi, The update command should be:
Update TABLENAME Set GE0METRY_COLUMN = dbo.ST_POINT(X_COLUMN, Y_COLUMN) Using you example Update TEST Set SW_GEOMETRY = dbo.ST_POINT(XDEZ, YDEZ) This should work for SpatialWare 4.6 or later. If you have a large number of records to update, then I would drop the R-Tree index before you start, and re-create it later. This will improve performance because the system doesn't have to update the index with every point that is created, it can do it all later. 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 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 2 February 2005 3:03 a.m. To: [email protected] Subject: MI-L Spatialware: update SW_GEOMTRY Dear List, I have an question according to an update on SQL-Server. -I spatialised a DB. -I created a table -- added to columns. SW_GEOMETRY and SW_MEMBER. -I spatialised Columns exec sp_sw_spatialize_column 'dbo','TEST','SW_GEOMETRY','SW_MEMBER' - I generated an R-Tree Index exec sp_sw_create_rtree 'dbo','TEST','SW_GEOMETRY','SW_MEMBER' - I inserted data from a another table INSERT INTO TEST (ID, Name, XDEZ, YDEZ) SELECT ID, Name, X_KOORD, Y_KOORD FROM TABLE_Temp And now I would like to store the PointInformation in SW_GEOMETRY!! and tried to to update the field: SW_GEOMETRY. UPDATE TEST set SW_GEOMETRY = 'ST_SPATIAL(ST_Point(XDEZ,YDEZ))' (the fields XDEZ and YDEZ are filled with floats.) But that failed!! Any help would be appreciated. Thanks in Advance. Mit freundlichen Gr��en microm Micromarketing-Systeme und Consult GmbH Hendrik Po�berg Manager Geodaten Hellersbergstr. 14 41460 Neuss Phone: 02131-10 97 51 Fax: 02131-10 97 77 mailto:[EMAIL PROTECTED] *** Aktuelles: Abonnieren Sie kostenlos das aktuelle microMagazin. In jedem Quartal aktuelle Informationen �ber die neuesten Entwicklungen bei microm, unseren Partnern und Kunden. Einfach online bestellen unter www.microm-online.de! *** ___________________________________________ Diese Nachricht wurde elektronisch versandt und ist daher auch ohne Unterschrift rechtsgueltig. Der Inhalt dieser E-Mail enth�lt vertrauliche Informationen. Das Kopieren und die Weitergabe an Dritte ist nicht gestattet. Sollten Sie diese E-Mail irrtuemlich von uns erhalten haben, bitten wir Sie, diese zu vernichten und uns darueber zu informieren. Im Voraus vielen Dank. ____________________________________________ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15077 ###################################################################### 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: 15084
