I have created an export operation that is exporting records based on a very specific list of criteria. I can get the filter I have written to work within a Browse, but when I copy the same criteria into an Export file it won't run. It does nothing. Any ideas as to why? I have A5v4.03.
It is a huge (to my sense) filter string. Would that have anything to do with it? Here's the string:
MARKED()=.F..AND.DELETED()=.F..AND.DOMFOR='F'.AND.(ISBLANK("HERENOW").OR.HERENOW=.F.).AND.ISBLANK("DTNOMAIL").AND.(ISBLANK("MAIL_ADMN").OR. MAIL_ADMN=.T.).AND. (SPKSENGLSH=.T..OR.ISBLANK("SPKSENGLSH")).AND. (IF((VAR->ASKC_SEASON_SUMMER_WINTER)='W',SEASON'S',SEASON'W')).AND.(COUNTRY="AUSTRALIA".OR.COUNTRY="AUSTRIA".OR.COUNTRY="BAHAMAS".OR.COUNTRY="BELGIUM".OR.COUNTRY="BERMUDA".OR.COUNTRY="CANADA".OR.COUNTRY="DENMARK".OR.COUNTRY="FINLAND".OR.COUNTRY="FRANCE".OR.COUNTRY="GERMANY".OR.COUNTRY="CHANNEL ISLANDS".OR.COUNTRY="ENGLAND".OR.*LEADING(COUNTRY,"GB").OR.COUNTRY="ISLE OF MAN".OR.COUNTRY="NORTHERN IRELAND".OR.COUNTRY="SCOTLAND".OR.COUNTRY="GREECE".OR.COUNTRY="GRENADA".OR.COUNTRY="IRELAND".OR.COUNTRY="ISREAL".OR.COUNTRY="ITALY".OR.COUNTRY="JAMAICA".OR.COUNTRY="JAPAN".OR.COUNTRY="NETHERLANDS".OR.COUNTRY="NEW ZEALAND".OR.COUNTRY="PORTUGAL".OR.COUNTRY="SPAIN".OR.COUNTRY="SWEDEN".OR.COUNTRY="SWITZERLAND".OR.COUNTRY="VIRGIN ISLANDS")
I have a work around by selecting export based on current selection of records, but I would rather not have to have the user run the browse before they export.
Thanks for whatever support you can give.
Jason Hunsberger
P.S. sounds like the conference was great!
It is a huge (to my sense) filter string. Would that have anything to do with it? Here's the string:
MARKED()=.F..AND.DELETED()=.F..AND.DOMFOR='F'.AND.(ISBLANK("HERENOW").OR.HERENOW=.F.).AND.ISBLANK("DTNOMAIL").AND.(ISBLANK("MAIL_ADMN").OR. MAIL_ADMN=.T.).AND. (SPKSENGLSH=.T..OR.ISBLANK("SPKSENGLSH")).AND. (IF((VAR->ASKC_SEASON_SUMMER_WINTER)='W',SEASON'S',SEASON'W')).AND.(COUNTRY="AUSTRALIA".OR.COUNTRY="AUSTRIA".OR.COUNTRY="BAHAMAS".OR.COUNTRY="BELGIUM".OR.COUNTRY="BERMUDA".OR.COUNTRY="CANADA".OR.COUNTRY="DENMARK".OR.COUNTRY="FINLAND".OR.COUNTRY="FRANCE".OR.COUNTRY="GERMANY".OR.COUNTRY="CHANNEL ISLANDS".OR.COUNTRY="ENGLAND".OR.*LEADING(COUNTRY,"GB").OR.COUNTRY="ISLE OF MAN".OR.COUNTRY="NORTHERN IRELAND".OR.COUNTRY="SCOTLAND".OR.COUNTRY="GREECE".OR.COUNTRY="GRENADA".OR.COUNTRY="IRELAND".OR.COUNTRY="ISREAL".OR.COUNTRY="ITALY".OR.COUNTRY="JAMAICA".OR.COUNTRY="JAPAN".OR.COUNTRY="NETHERLANDS".OR.COUNTRY="NEW ZEALAND".OR.COUNTRY="PORTUGAL".OR.COUNTRY="SPAIN".OR.COUNTRY="SWEDEN".OR.COUNTRY="SWITZERLAND".OR.COUNTRY="VIRGIN ISLANDS")
I have a work around by selecting export based on current selection of records, but I would rather not have to have the user run the browse before they export.
Thanks for whatever support you can give.
Jason Hunsberger
P.S. sounds like the conference was great!
Comment