PDA

View Full Version : Selecting records based on multible values in similar fields



Larry Schroeder
6-Oct-2005, 09:42 AM
It seems that this would be somewhat east to do. I want to select records
based on different values in similar fields. Whe I search through the field
index I want to look for mre then just one variable. Curerntly it just looks
for the value of 10. I want to add two more values. How can I do that? Here
is what I have so far.
Thanks!
Larry

CLEAR PRESSLBR

MOVE O.1 TO PRESSLBR.DATE

MOVE O.4 TO PRESSLBR.BAI_PART

REPORT PRESSLBR BY INDEX.1 BREAK PRESSLBR.BAI_PART PRESSLBR.DATE

INDICATE SELECT AS PRESSLBR.DATE GE O.1

[ SELECT] INDICATE SELECT AS PRESSLBR.DATE LE O.2

[ SELECT] INDICATE SELECT AS PRESSLBR.BAI_PART EQ O.4

IFNOT PRESSLBR.BAI_PART EQ O.4 RETURN END.OF.REPORT

FOR FIELDINDEX FROM 0 TO 7

[ SELECT] INDICATE SELECT AS PRESSLBR.CODE_1& EQ "10"

[~SELECT] UNTIL PRESSLBR.CODE_1

Larry R Pint
6-Oct-2005, 12:02 PM
Larry Schroeder wrote:
> It seems that this would be somewhat east to do. I want to select records
> based on different values in similar fields. Whe I search through the field
> index I want to look for mre then just one variable. Curerntly it just looks
> for the value of 10. I want to add two more values. How can I do that? Here
> is what I have so far.
> Thanks!
> Larry
>
> CLEAR PRESSLBR
>
> MOVE O.1 TO PRESSLBR.DATE
>
> MOVE O.4 TO PRESSLBR.BAI_PART
>
> REPORT PRESSLBR BY INDEX.1 BREAK PRESSLBR.BAI_PART PRESSLBR.DATE
>
> INDICATE SELECT AS PRESSLBR.DATE GE O.1
>
> [ SELECT] INDICATE SELECT AS PRESSLBR.DATE LE O.2
>
> [ SELECT] INDICATE SELECT AS PRESSLBR.BAI_PART EQ O.4
>
> IFNOT PRESSLBR.BAI_PART EQ O.4 RETURN END.OF.REPORT
>
> FOR FIELDINDEX FROM 0 TO 7
>
> [ SELECT] INDICATE SELECT AS PRESSLBR.CODE_1& EQ "10"

[~select] indicate select as presslbr.code_1& eq "8"
[~select] indicate select as presslbr.code_1& eq "AB"

and for other fields:

[~select] indicate select as presslbr.anotherfield eq "XYZ"

Larry Pint

>
> [~SELECT] UNTIL PRESSLBR.CODE_1
>
>