nuBuilder Forum

Posted: **Fri Jan 26, 2018 6:51 am**

Hi,

In nuBuilderPro, I set a hash variable in the form's js section:

nuSetHash('empFlagActive','1');

lookup.PNG

The lookup form's sql uses this variable in the where clause to show only the active employees:

SELECT * FROM emp_table WHERE emp_active = '#empFlagActive#'

How to do this with nuBuilderForte? nuSetProperty() doesn't seem to be the right function to use.

Posted: **Sat Jan 27, 2018 4:49 am**

toms,

You'll need the latest from Github but

You can use nuSetProperty()

http://wiki.nubuilder.net/nubuilderfort ... etProperty

Steven

Posted: **Sat Jan 27, 2018 9:34 am**

Thanks Steven, it works now!

Posted: **Sat Jan 27, 2018 9:49 am**

Lookup Control / pass variable