And, of course, I mixed variables on my first post to the group. It should read:
SET VAR PropertyTest TEXT = NULL SELECT MenuPerm INTO PropertyTest FROM AccessLevel WHERE Level = .vAccessLevel PROPERTY MenuItem VISIBLE PropertyTest Jim McPherson | IT Manager JJ Calibrations | (503) 786-3005 [email protected] From: [email protected] <[email protected]> On Behalf Of [email protected] Sent: Thursday, December 5, 2019 3: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/003601d5abc3%2454fc4910%24fef4db30%24%40jjcalibrations.com.
