We're trying find a solution that allows us to bulk change from one hold code to another on a performance.
I wrote this basic SQL update statement with the intent to create a custom utility that could be run via the application:
update tx_perf_hc
set hc_no =
from
where hc_no =
and perf_no =
It seems to work but I might be missing other tables that need updating as well?
Would love some insight.
Thanks!
Hi Wes,
I find an easy way to get an idea if anything else is happening is to use the Log Viewer in Tessitura (under the Help menu). Set it to trace, then do the thing in Tessitura you're trying to script (so in your case change the hold on a seat) then look in the log viewer output for what tables are updated.
CheersSarah
Hey Sarah - again, just seeing this - missed it way back when you posted I'm afraid. That's a great idea, this will be very useful for a few other projects on the go.
wes