Expand "if" command

[graves]

Hi
1. It would be very useful to have a command "between" (like SQL). At this momment I'm using this macro

Code: Select all

macro between(btwfld, btwfrm, btwto)
  btwfld >= btwfrm AND btwfld <= btwto
endmacro

...
if between(datafield, valuefrom, valueto) ...

But it would be much more readable this construct:

Code: Select all

if datafield between valuefrom and valueto ...

2. Also we need to check same datafield against a lot of values (chained by OR), like this:

Code: Select all

if datafield = value1 OR value2 OR value3 ... 

Instead, I can use this construct:

Code: Select all

select datafield
  case value1, value2, value3:,,,
  default: ...
endselect

But it's not the same thing

BOTH cases can be unified in the next (generic) construct:

Code: Select all

if datafield [>=<] value1 [AND,OR] [>=<] value2 ....

[PB]

But it would be much more readable this construct:

Code: Select all

if datafield between valuefrom and valueto ...

I don't understand? How is the above any different to just doing this:

Code: Select all

if value(datafield)=>valuefrom and value(datafield)<=valueto

[AND51]

Why not doing this:

Code: Select all

value=59

Select value
   Case 1 To 10, 90 To 100
      Debug "between 1-10 or 90-100"
   Case 14, 24, 34, 44, 54, 64, 74, 84
      Debug "value ends with 4"
   Case 35 To 41, 43
      Debug "value between 35-41 or equal to 43"
   Default
      Debug "any other value"
EndSelect

[Mistrel]

If you're using OR statements you should group each part of the expression in parenthesis:

Code: Select all

(btwfld >= btwfrm And btwfld <= btwto) Or (N=2 And R=1)

This is the proper way to make this kind of statement 'more readable'.

[luis]

[quote="graves"]Hi
1. It would be very useful to have a command "between" (like SQL). At this momment I'm using this macro

Code: Select all

macro between(btwfld, btwfrm, btwto)
  btwfld >= btwfrm AND btwfld <= btwto
endmacro

...
if between(datafield, valuefrom, valueto) ...

Hi, I believe it's really something you can already do in many ways without the need to add another keyword to the language.