RE: [RBASE-L] - PROPERTY Command Using Variable Toggle?

[Buddy Walker]

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)



 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of 
jim.mcpher...@jjcalibrations.com
Sent: Thursday, December 5, 2019 6:22 PM
To: rbase-l@googlegroups.com
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 rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
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_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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002d01d5ac36%24a9119190%24fb34b4b0%24%40comcast.net.

RE: [RBASE-L] - PROPERTY Command Using Variable Toggle?

[Jim Belisle]

Jim,

You may want to try an IF THEN statement

SELECT MenuPerm INTO PropertyTest FROM AccessLevel WHERE Level = .vAccessLevel
IF propertytest = whatever THEN
PROPERTY MenuItem VISIBLE ‘TRUE’
ENDIF

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
jim.mcpher...@jjcalibrations.com
Sent: Thursday, December 5, 2019 5:26 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - PROPERTY Command Using Variable Toggle?

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
jim.mcpher...@jjcalibrations.com

From: rbase-l@googlegroups.com  On Behalf Of 
jim.mcpher...@jjcalibrations.com
Sent: Thursday, December 5, 2019 3:22 PM
To: rbase-l@googlegroups.com
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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_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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CH2PR02MB70472FAF8CB7D790EE061D2FA05F0%40CH2PR02MB7047.namprd02.prod.outlook.com.

RE: [RBASE-L] - PROPERTY Command Using Variable Toggle?

[jim.mcpherson]

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

jim.mcpher...@jjcalibrations.com

 

From: rbase-l@googlegroups.com  On Behalf Of 
jim.mcpher...@jjcalibrations.com
Sent: Thursday, December 5, 2019 3:22 PM
To: rbase-l@googlegroups.com
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 rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
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_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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/003601d5abc3%2454fc4910%24fef4db30%24%40jjcalibrations.com.

[RBASE-L] - PROPERTY Command Using Variable Toggle?

[jim.mcpherson]

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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002701d5abc2%24d7545110%2485fcf330%24%40jjcalibrations.com.

Re: [RBASE-L] - Property command

[karentellef via RBASE-L]

But if the view has >1 table, then the view would not be editable.  So this 
would work only if the DBGrid was read-only, right?

Karen

 

 

 

-Original Message-
From: A. Razzak Memon <raz...@rbase.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, Dec 8, 2016 3:30 pm
Subject: Re: [RBASE-L] - Property command

In that case, define a custom VIEW with all lookups, etc.

Then, assign the Enhanced DBGrid to that custom VIEW to accomplish your goal.

Sometimes you just have to think outside the box :)

Very Best R:egards,

Razzak


At 04:17 PM 12/8/2016, Tom Hart wrote:

>I think my problem is I have a lookup, can that be done in a dbgrid?
>Tom
>
>On Thu, Dec 8, 2016 at 3:05 PM, A. Razzak Memon <raz...@rbase.com> wrote:
>Switch your control from Scrolling Region to Enhanced DBGrid control.
>
>Using the Enhanced DBGrid control, you can customized each cell of a
>column, including cell background/font color, based on column value.
>
>Very Best R:egards,
>
>Razzak
>
>
>At 03:16 PM 12/8/2016, Tom Hart wrote:
>
>Using Rbase X have a scrolling region for that has a field with 'T'
>taxable or 'N' nontaxable.  If it is 'T' I want it to show green,
>if 'N' to show red.  What is the best to accomplish this
>
>
>
>--
>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 
>rbase-l+unsubscr...@googlegroups.com.
>For more options, visit https://groups.google.com/d/optout.
>
>
>--
>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 
>rbase-l+unsubscr...@googlegroups.com.
>For more options, visit https://groups.google.com/d/optout.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Property command

[Tom Hart]

Based on an itemNumber I lookup all relevant info from that, can that be
accomplished in a dbgrid?
Tom

On Thu, Dec 8, 2016 at 3:17 PM, Tom Hart  wrote:

> I think my problem is I have a lookup, can that be done in a dbgrid?
> Tom
>
> On Thu, Dec 8, 2016 at 3:05 PM, A. Razzak Memon  wrote:
>
>> Switch your control from Scrolling Region to Enhanced DBGrid control.
>>
>> Using the Enhanced DBGrid control, you can customized each cell of a
>> column, including cell background/font color, based on column value.
>>
>> Very Best R:egards,
>>
>> Razzak
>>
>>
>> At 03:16 PM 12/8/2016, Tom Hart wrote:
>>
>> Using Rbase X have a scrolling region for that has a field with 'T'
>>> taxable or 'N' nontaxable.  If it is 'T' I want it to show green,
>>> if 'N' to show red.  What is the best to accomplish this
>>>
>>
>>
>> --
>> 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 rbase-l+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Property command

[Tom Hart]

I think my problem is I have a lookup, can that be done in a dbgrid?
Tom

On Thu, Dec 8, 2016 at 3:05 PM, A. Razzak Memon  wrote:

> Switch your control from Scrolling Region to Enhanced DBGrid control.
>
> Using the Enhanced DBGrid control, you can customized each cell of a
> column, including cell background/font color, based on column value.
>
> Very Best R:egards,
>
> Razzak
>
>
> At 03:16 PM 12/8/2016, Tom Hart wrote:
>
> Using Rbase X have a scrolling region for that has a field with 'T'
>> taxable or 'N' nontaxable.  If it is 'T' I want it to show green,
>> if 'N' to show red.  What is the best to accomplish this
>>
>
>
> --
> 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 rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Property command

[A. Razzak Memon]

Switch your control from Scrolling Region to Enhanced DBGrid control.

Using the Enhanced DBGrid control, you can customized each cell of a
column, including cell background/font color, based on column value.

Very Best R:egards,

Razzak


At 03:16 PM 12/8/2016, Tom Hart wrote:


Using Rbase X have a scrolling region for that has a field with 'T'
taxable or 'N' nontaxable.  If it is 'T' I want it to show green,
if 'N' to show red.  What is the best to accomplish this



--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Property command

[jan johansen]

Tom,

I believe in a scrolling region you will only be able to change the color 
based on the current 'row' if that makes a difference to you.
Otherwise a DB grid or variable list will show all 'T' as green.

Jan
-Original Message-
From: Tom Hart <tooma...@gmail.com>
To: rbase-l@googlegroups.com
Date: Thu, 8 Dec 2016 14:16:48 -0600
Subject: [RBASE-L] - Property command


Using Rbase X have a scrolling region for that has a field with 'T' taxable 
or 'N' nontaxable.  If it is 'T' I want it to show green, if 'N' to show 
red.  What is the best to accomplish this

Tom Hart
 --
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 rbase-l+unsubscr...@googlegroups.com 
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout 
[https://groups.google.com/d/optout].

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.