Is vvIn_Virtual valid for data sources for dropdowns?
I have the following data source defined for a dropdown on a form.
The app variable 'companyNumber' is used throughout my app. However, the drop down is only showing the two values from the "OR" in the where statement above (where com_nbr='***')
It's like the default value is being replaced
(in this case the app variable companyNumber is the default value of '009' )
I have the following data source defined for a dropdown on a form.
Code:
SELECT sales_rep_nbr, trim(sales_rep_nbr) || ' (' || trim(sales_rep_name) || ')' AS sales_rep_name FROM v_slsreps WHERE ( com_nbr = vvin_virtual('companyNumber', '009', 'char', 3, NULL, 'true') or com_nbr = '***' ) ORDER BY sales_rep_nbr
It's like the default value is being replaced
(in this case the app variable companyNumber is the default value of '009' )
Comment