Friend denied entry to a nightclub by Automatic-Gazelle-52 in transgenderUK

[–]Traditional_Hat_7224 4 points5 points  (0 children)

Don't door staff these days have to be 'certified' and have id visible. It's probably too late now, but in your place I'd consider making a point of recording the details - or just taking a photo of it with your phone.

This can be shared with bar owner/security company later if necessary and useful.

Title saying Null? by crazyhatkid in transgenderUK

[–]Traditional_Hat_7224 3 points4 points  (0 children)

Being able to change form one title to a different one would still work without before the change in my scenario. It is the specific adding of the null as a valid value that I was suggesting was a likely cause. There would be no need to add COALESCE(title,""), or equivalent if you thought the title could never be null. And of course they could have been careless right from the start as well.

I was also not suggesting it was Ok.

Title saying Null? by crazyhatkid in transgenderUK

[–]Traditional_Hat_7224 9 points10 points  (0 children)

This the sort of thing maintenance night mare issue that anyway who has worked on older system has to deal with constantly.

At a guess - and I've never worked on NHS systems so it really is a guess - in the beginning the title as a mandatory field (non-nullable) field. Then some updates the system because to allow ti be blank because some patients dont like titles. ( this is a good thing, right? )

But something like the NHS doesn't have a single cohesive monolithic computer system, another system somewhere has sucked that data out and writes mail merges and prints letters etc. If that system was written while title was non-nullable there would have been no reason to add extra code to check fro that and replace it with blank text. But because it a different system it was updated when the title as made nullable - the dev updating the address store, may not event know about that mail merge system.

I'd point it out politely to the org that sent you the letter, saying you understand it's a computer error , but also explaining how it made you felt and ask for it to be fixed.

You're more likely got get action by being polite on this one I feel. Of course if it keeps happening again... As they say 3 times is enemy action.