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
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.