- Tue Dec 10, 2019 4:46 am
#827125
Hi
I am trying to use SQL query to set the value of a hidden control but it dos not work. I have set the SQL part of hidden control to this :
select USR_USERNAME
from users
where USR_UID <> '00000000000000000000000000000001' and USR_STATUS='ACTIVE' and USR_UID = "@#suggestUser01"
But nothing happens when the suggestion box (#suggestUser01) is changed. This SQL statement works properly with text box. Also there is no problem with SQL without using variables (fixed parameters).
I am trying to use SQL query to set the value of a hidden control but it dos not work. I have set the SQL part of hidden control to this :
select USR_USERNAME
from users
where USR_UID <> '00000000000000000000000000000001' and USR_STATUS='ACTIVE' and USR_UID = "@#suggestUser01"
But nothing happens when the suggestion box (#suggestUser01) is changed. This SQL statement works properly with text box. Also there is no problem with SQL without using variables (fixed parameters).