We have a large group of records in our database that we need to inactivate their constituent records.
Does anybody know of a procedure that can handle this en masse from a list
This may be too crude to use since I'm not sure what other actions might be triggered when you inactivate a constituent from witin the client, but from the database I might try something like
update t_customer
set inactive = 1
where customer_no in (
select customer_no
from t_list_contents
where list_no = ###
)
Or would that be too much like using a stone axe to cut down a tree?
Levi, you are close. The inactive_reason would need to be set for the inactive constituents as well.
Best,
Anna
Anna E. Wessely
Manager Asia Pacific/Senior Application Specialist
Tessitura Network, Inc
+1 888 643 5778 x 308
awessely@tessituranetwork.com
www.tessituranetwork.com
Thank You Anna & Levi;
I did run this in test an it work the second item to note the inactive has to be set to 2 not one as 1 is the default.
set inactive = 2,
inactive_reason = 3
Kind regards,
Joe Shafranek
Director of Systems Westport Country Playhouse
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Anna Wessely Sent: Thursday, June 11, 2009 3:12 PM To: Joseph C. Shafranek Subject: Re: [Tessitura Technical Forum] inactivate constituent records
From: Levi Sauerbrei <bounce-levisauerbrei8271@tessituranetwork.com> Sent: 6/11/2009 1:25:26 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!