Hi there,
Where in the database are the four 'Ticket Text' fields for each performance stored?
I want to do a bulk update of all performances in a Production Season.
I've had a little poke around the database and it doesn't seem to be anywhere obvious (although I'm sure that it is)
Thanks!,Daniel.
Hi Daniel
They're in .[T_INVENTORY],
- which has a row for each Title, production, production season, and perf. (the .Type field tells you which)
The key is inv_no, which links to the Perf_no or other id field..
You might want to keep your eye on the ,fulltext field as well, if you're manually updating the .textn fields.
Ken
Of course! Perfect, thankyou.