Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following code for the Section Access in Edit Script. I am not getting any of the values for the PB_Charge_CostCenterNamethe such as Cardiology to be selected upon logging in as Mickey or anyone in the code (Minnie, etc). None of the
[fPB_Charge]:
load
CostCenterName AS PB_Charge_CostCenterName
;
sql select
CostCenterName
from DW.cfn_Lookup_PB_Charges_Staging()
;
SECTION Access;
Authorization:
Load * Inline
[Access, Userid, Password, fPB_Charge.PB_Charge_CostCenterName
ADMIN, QTRAN, PASS1,
USER, MICKEY, PASS1, CARDIOLOGY
USER, MINNIE, PASS1, ENT
USER PLUTO, PASS1, GASTROENTEROLOGY
USER PLUTO, PASS1, ALLERGY CLINIC
];
I capitalized CostCenterName using upper(CostCenterName) and it now works.
The fPB_Charge.PB_Charge_CostCenterName does not contain any selections when I log in using the above accounts such as Mickey. I have also tried just with PB_Charge_CostCenterName and that did not work.
I added a comma after user and pluto (user, pluto) but I still have the problem of not getting anything selected for the PB_Charge_CostCenterName listbox
USER PLUTO, PASS1, GASTROENTEROLOGY
USER PLUTO, PASS1, ALLERGY CLINIC
I capitalized CostCenterName using upper(CostCenterName) and it now works.