[arash125]

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).

[programerboy]

Hi,
Related variables don't support on hidden fields, you can use a textbox field and hide it onload your dynaform and set your query on it.

https://pmlearning.info
Thanks

[arash125]

Thanks a lot.