Activity overview
Latest activity by patrick_j
Very good to know. I assumed the opposite and moved them all to be running separately so I'll change that on my next revision. / comments
Very good to know. I assumed the opposite and moved them all to be running separately so I'll change that on my next revision.
Yes, thank you. I was able to solve that challenge with your help. / comments
Yes, thank you. I was able to solve that challenge with your help.
Hi PBS. In the case that I've referred to, I don't think there is a reason why both fields couldn't be handled in the same rule. Where can I find some guidelines regarding when and when not to have multiple fields in one Substitution rule such as this? / comments
Hi PBS. In the case that I've referred to, I don't think there is a reason why both fields couldn't be handled in the same rule. Where can I find some guidelines regarding when and when not to have...
Deadlock question
I am getting random deadlocking when Substitution rules are running within 1 table such as, "Transaction (Process ID 77) was deadlocked on lock resources with another process and has been chosen as...
I'm answering my own question. CASE returns NULL when no condition evaluates to True and there is no ELSE clause. The first-step conversion of all rows to Male is therefore not required when using a CASE if the ELSE evaluates as that. / comments
I'm answering my own question. CASE returns NULL when no condition evaluates to True and there is no ELSE clause. The first-step conversion of all rows to Male is therefore not required when using ...
Substitution unexpected behaviour
For a table of Clients, using a Substitution rule I first updated all FirstName with dataset Names, First Name, Male. I followed that with a dependent Row Internal Rule to update by Salutation with...
Issue with Substitution rule screen
Using Data Masker 7.0.16, when editing a Substitution rule, if a field has a dataset selected, if you click open its dropdown the selected dataset is not pre-selected in the dropdown list. The resu...
Changing 01-0013 to a Fast Single Pass might have fixed this. I'll know when I test the entire rule set again. I'm open to other suggestions though. / comments
Changing 01-0013 to a Fast Single Pass might have fixed this. I'll know when I test the entire rule set again. I'm open to other suggestions though.
First Name, Last Name Substitution hangs
I set up a Substitution on FirstName and LastName fields as Rule 01-0004 using data sets. I then set up a Row-Internal on a LastFirstName field as Rule 01-0013 as LastName+', '+FirstName. This was ...
I'm using the most recent Firefox. The same thing occurs on two machines. I start a class and after a few seconds I am redirected to https://www.red-gate.com/hub/university/courses/sql-provision/sql-provision. This does not happen with Microsoft Edge. Firefox plugins Disconnect and UBlock Origin are installed but disabled.Firefox Tracking Protection set to Stardard Level. For now I'll just use Edge. / comments
I'm using the most recent Firefox. The same thing occurs on two machines. I start a class and after a few seconds I am redirected to https://www.red-gate.com/hub/university/courses/sql-provision/sq...