Cursor in menu item code not returning correct database value
We have a table called system_parameters
The value of one of the system_parameter records can be either C or O.
Code behind a menu item checks the value of the system_parameter record before deciding on which processing path to take.
We came across a situation recently where the menu item code took the processing path when the value of the system parameter being C even though the actual value of the system parameter was O
In short
The value of the system_parameter record is O
When we check the value of the system parameter using SQL+ O is returned.