GET_SESSION_VALUE with the key USER returns exact case which can lead to problems for login or data retrieval

Date: 24 April 2008
Product/Release: Visual LANSA V11 SP4
Abstract: GET_SESSION_VALUE in V11 SP4 return USER key in exact case
Submitted By: LANSA Technical Support


In V11 SP4, if you use the builtin function GET_SESSION_VALUE with the key USER, the USER returns the value entered for USER on the command line in the exact case it was entered.

E.g: If the user entered 'AbCd' for the value for USER, then 'AbCd' is what V11 SP4 will return, matching the exact case that it was entered.

Prior to v11 SP4, the value for USER was always in UPPERCASE.


A solution is available that reverts to 11.3 behavior. The long term solution will fix this issue by uppercasing USER and adding a new key of USEX to return the exact case of the user parameter.

Example problem: If you have written code to use USER as a key to a table, the data would not be found in V11 SP4.