Jim you could use and ampersand before the variable and instead of a dot. This will cause the variable to execute.
SET VAR vDoProperty TEXT = NULL SET VAR vQuotes = (CVAL(‘QUOTES’)) SET VAR MenuPerm TEXT = NULL SELECT MenuPerm INTO PropertyTest FROM AccessLevel WHERE Level = .vAccessLevel PROPERTY MenuItem VISIBLE PropertyTest SET VAR vDoProperty = (‘PROPERTY MenuItem VISIBLE’ & .vQuotes + .PropertyTest + .vQuotes) &vDoProperty Buddy From: [email protected] <[email protected]> On Behalf Of [email protected] Sent: Thursday, December 5, 2019 6:22 PM To: [email protected] Subject: [RBASE-L] - PROPERTY Command Using Variable Toggle? Greetings all, I’m new to the group and almost as new to R:Base so I hope my questions are not too basic for this group. Anyway, on to this one… Can you use a variable in the place of ‘TRUE’ or ‘FALSE’ on the PROPERTY command? For instance, I have a menu that I would like to remain hidden based on a table value. Here’s what I’m trying: SET VAR MenuPerm TEXT = NULL SELECT MenuPerm INTO PropertyTest FROM AccessLevel WHERE Level = .vAccessLevel PROPERTY MenuItem VISIBLE PropertyTest I’ve vetted the SELECT statement to ensure it’s getting the correct value but using the variable as the toggle doesn’t seem to work. Thoughts? Jim McPherson -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/002701d5abc2%24d7545110%2485fcf330%24%40jjcalibrations.com <https://groups.google.com/d/msgid/rbase-l/002701d5abc2%24d7545110%2485fcf330%24%40jjcalibrations.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/002d01d5ac36%24a9119190%24fb34b4b0%24%40comcast.net.
