By richvle - Mon Jun 06, 2022 7:55 pm
- Mon Jun 06, 2022 7:55 pm
#829968
Depends on the value of a variable, I would like to modify the SQL dynamically of a dropdown control. I'm not just modifying the where clause. I'm modifying the table and select.
For example....
if A==True
then set SQL: "select userid, username from users where age>=@@AgeVar"
else set SQL: "select colorid, colorname from players where favoriteColor = @@ColorVar".
For example....
if A==True
then set SQL: "select userid, username from users where age>=@@AgeVar"
else set SQL: "select colorid, colorname from players where favoriteColor = @@ColorVar".
- By Lisamorris