5/22/2025 8:26:41 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.
|
|
|
|
Delete Multiple Rows through Workgroup Admin
Posted: 05 Mar 08 9:59 AM
|
Over the past year I have run into a problem many times where I wanted to delete a few rows in the Workgroup Administrator so the deletes would sync out to my remotes. When I do something like
"delete from account where accountid in ('accountid1', 'accountid2')"
The statement fails because more than one record was returned, is there a way to work around this? I have to delete 406 rows and I'm not looking forward to entering 406 lines into WG admin.
 |
|
|
|
Re: Delete Multiple Rows through Workgroup Admin
Posted: 05 Mar 08 3:40 PM
|
Hi Ian
I suggest it would be much easier and safer to use the Sales Client (as "Admin") to create an Ad Hoc group, then use Tools | Maintenance | Purge based on that group. he advantage of that is that it will also take care of any child records such as Contact, Opportunity, etc...
As an alternative to an Ad Hoc group, you can use the "In" condition and a list of AccountIds when constructing the where clause of a query-based group.
I know it's a slower delete, but there are only 400-odd records, not tens of thousands.
Hope that helps
Paul Roussell
Adexio Pty Ltd
Brisbane, Australia
SalesLogix Partner since 1997 |
|
|
|
Re: Delete Multiple Rows through Workgroup Admin
Posted: 05 Mar 08 4:46 PM
|
Paul,
Thank you for the quick reply. I'm actually not deleting Account records, I'm deleting records in a custom table. I was just using the account delete as an example (probably a bad choice), so purge won't work for me.
I just tried this in my Development database for version 7.0.1 and the SQL worked, so maybe this is a problem with the Execute SQL in version 5.2 and I'm confused.
Sorry for the false alarm, I think I'm all set now. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|