topic Re: Delete rows/features from SQL Server spatial in Data Management Questions

Delete rows/features from SQL Server spatial

VytautasGipiskis — Mon, 05 Sep 2011 14:35:52 GMT

Hello,

Created empty database to store spatial information (no GDB), copied/pasted data into it. Works really nice. Now I want to delete some/all features from this spatial table: tried to use "delete rows" and "delete features" GP tools - none of them works, both produces ERROR 999999: Error executing function.
What I'm doing wrong ?

Best Regards,
Vytautas

Re: Delete rows/features from SQL Server spatial

JoshuaBixby — Tue, 06 Sep 2011 14:07:58 GMT

I can't say it directly answers your question, but it might be worth your time to look over the Editing Sql Server without ArcSDE thread in the ArcGIS Desktop forum.

Re: Delete rows/features from SQL Server spatial

VytautasGipiskis — Tue, 06 Sep 2011 17:15:45 GMT

Thanks for pointing this. Just 2 observations:
- Why load (insert) works and delete does not ?
- probably error code 999999 is a most meaningful message after famous ArcView 2.x/3.x "segmentation violation" message.... 🙂

Regards,
Vytautas

Re: Delete rows/features from SQL Server spatial

BrentPierce — Wed, 07 Sep 2011 17:40:21 GMT

Vytautas,

We are working to address issues with the Delete Rows/Features tools when executed against database tables for a future beta release. In the mean time, you should be able to use the Truncate Table GP Tool (Data Management Tools Toolbox > Table Toolset) to truncate the table in the database.

Hope this helps,
-Brent

Re: Delete rows/features from SQL Server spatial

VytautasGipiskis — Thu, 08 Sep 2011 05:34:23 GMT

Hi Brent,
Thanks for update. Can you update GP messages as well ? 999999 is not most informant message 🙂

Best Regards,
Vytautas

Re: Delete rows/features from SQL Server spatial

BrentPierce — Thu, 08 Sep 2011 15:36:50 GMT

Yes, we are also working on providing a better error message when these tools fail. 99999 is only really useful if it's your bank account balance. 😄