[RBASE-L] - Re: IF Question

[Dan Goldberg]

Try Tracing it and stepping through the lines. I would check the values and the 
if statement to see if they are what you expect and watch for warnings.

Dan



From: Javier Valencia 
Sent: Monday, April 22, 2013 7:01 AM
To: RBASE-L Mailing List 
Subject: [RBASE-L] - Re: IF Question
Alastair,

 

I have tried with and without parentheses and also each individual expression 
with and without parentheses with the same result. I am baffled.

 

Javier,

 

Javier Valencia, PE

O: 913-829-0888

H: 913-397-9605

C: 913-915-3137

 

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of Alastair Burr
Sent: Monday, April 22, 2013 2:12 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: IF Question

 

Javier,

 

I don’t think you need the brackets around the two statements, so:

IF vreq_category = 'S' AND vsms_access < 40 THEN ...

should work.

 

Regards,

Alastair.

 

From: Javier Valencia 

Sent: Monday, April 22, 2013 7:57 AM

To: RBASE-L Mailing List 

Subject: [RBASE-L] - IF Question

 

I have variable in code  that I need to check to verify if the process can
continue. I have two defined variables:

SET VAR vreq_category TEXT = 'S'
SET VAR vsms_access INTEGER = 30

Now, if vreq_category = 'S' AND vsms_access is less than 40 then an warning
message is generated.
If vreq_category is not equal to 'S" then no warning is issued.
If vrew_category = 'S' and vsms_access is eaula or greater than 40 then no
warning  is issued.

The following code works correctly"

SET VAR vreq_category TEXT = 'S'
SET VAR vsms_access INTEGER = 30
IF vreq_category = 'S' THEN
   IF vsms_access < 40 THEN
      SET VAR vMsg = ('You need SMS access level 40 or higher' + CHAR(13) +
      + 'To create Sign work Order.' + CHAR(13) )
      PAUSE 2 USING .vMsg CAPTION 'System Message...' +
      ICON Warning +
      BUTTON 'Press any key to continue...' +
      OPTION THEMENAME &vUser_theme
      GOTO Done
   ENDIF
ENDIF
...
LABEL Done

Now, if I combine the IF statements, the warning code is bypassed:

SET VAR vreq_category TEXT = 'S'
SET VAR vsms_access INTEGER = 30
IF (vreq_category = 'S' AND vsms_access < 40) THEN
  SET VAR vMsg = ('You need SMS access level 40 or higher' + CHAR(13) +
  + 'To create Sign work Order.' + CHAR(13) )
  PAUSE 2 USING .vMsg CAPTION 'System Message...' +
  ICON Warning +
  BUTTON 'Press any key to continue...' +
  OPTION THEMENAME &vUser_theme
  GOTO Done
ENDIF
...
LABEL Done

If I change the "AND" to "OR" the code is executed, but I need it to
evaluate both conditions at the same time and not one or the other.

I don't know if I am too sleepy and can't see the obvious but I would think
that both snippets of code should work...I am probably overlooking something
obvious.

TIA.

Javier,

Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137