tays01s

SQL: Selecting from a script variable

Discussion created by tays01s on Sep 16, 2018
Latest reply on Sep 21, 2018 by beverly

Can I use something like:

ExecuteSQL("SELECT (" & $Tx_nut & ") FROM \"Tox\" WHERE  etc.

where $Tx_nut was set earlier in the script?

 

I'm finding the variable is set OK but using a variable instead of a field name elicits a script error in the Data viewer.

Outcomes