Using "OR" is report form line

[Richardkl]

foxpro 2.6

I use the following command line

report form c:\simple\RESET.frm for VENDOR1 <> "EDISON" OR VENDOR1 <> "CAPITOL" OR VENDOR1 <> "EDISON" PREVIEW

I get those names still showing in the report. Is there away to not get those names in a report

 

[dbMark]

report form c:\simple\RESET.frm for VENDOR1 <> "EDISON" AND VENDOR1 <> "CAPITOL" AND VENDOR1 <> "EDISON" PREVIEW

Here is another way to say the same thing, but it will be easier to add additional words to filter:

report form c:\simple\RESET.frm for NOT ALLTRIM(VENDOR1) $ "EDISON,CAPITOL,EDISON" PREVIEW

dbMark

 

[alvechurchdata]

report form c:\simple\RESET.frm for VENDOR1 <> "EDISON" OR VENDOR1 <> "CAPITOL" OR VENDOR1 <> "EDISON" PREVIEW[\quote]

The problem lies in the OR operator because it will return .T. if any one of the expressions is true. If VENDOR1 is equal to "EDISON" then it's not equal to "CAPITOL" and the second part of your FOR clause will evaluate as .T. and the record will print.

Use AND like dbMark suggests.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[JRB-Bldr]

report form c:\simple\RESET.frm for VENDOR1 <> "EDISON" OR VENDOR1 <> "CAPITOL" OR VENDOR1 <> "EDISON" PREVIEW

NOTE: That above you are redundantly excluding "EDISON"

Some other possible code alternatives

ALLTRIM(Vendor1) is NOT (!) included in the following string...

  REPORT FORM c:\simple\RESET.frm ;
    FOR !(ALLTRIM(VENDOR1) $ "EDISON,CAPITOL,EDISON") ;
    PREVIEW

ALLTRIM(Vendor1) is NOT (!) in the list that follows...

  REPORT FORM c:\simple\RESET.frm ;
    FOR !INLIST(ALLTRIM(VENDOR1),"EDISON","CAPITOL","EDISON") ;
    PREVIEW

Good Luck,

JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[dbMark]

Yes, I noticed that the first and third words were duplicates, but left them as is. But now I notice my sample would not have worked correctly, as it would have also excluded smaller words such as "ED", "SON" or "PIT". This is better, but requires that the string containing the words always begin and end with a comma, in other words, a delimiter:

REPORT FORM c:\simple\RESET.frm ;
    FOR !(","+ALLTRIM(VENDOR1)+"," $ ",EDISON,CAPITOL,EDISON,") ;
    PREVIEW

I do agree the INLIST() function is a better solution.

 

[Richardkl]

Thanks guys, the use of "for NOT ALLTRIM(VENDOR1) " was the solution to my problem