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.
Sorry, one more question - what is the fulltext field used for? Can problems potentially arise if there is a mismatch between fulltext and textn?
I think it's just there to enable/speed up the fulltext search capability. But don't quote me.
That fulltext string looks quite fiddly and a lot of work to reconstitute, now that I look at it more closely.
Makes sense.
Looks like there's a TP_POPULATE_FULLTEXT function that I could probably run over the affected rows, but I reckon it'll be fine as is.
Thanks again for your help.
- Daniel.