setting high date and PFCMARK

Bruce Easton bruce at stn.com
Thu Apr 9 07:45:04 PDT 2009


(top post)
 
Richard - a couple of quick things to check - did you try to rebuild index
H?  Also, does your 
script line that executes this report still have the -iH on it?
 
Bruce
 
Bruce Easton
STN, Inc.


  _____  

From: filepro-list-bounces+bruce=stn.com at lists.celestial.com
[mailto:filepro-list-bounces+bruce=stn.com at lists.celestial.com] On Behalf Of
Richard D. Williams
Sent: Thursday, April 09, 2009 10:30 AM
To: scooter6 at gmail.com
Cc: filePro Mailing List
Subject: Re: setting high date and PFCMARK


Try this;

If: dl ne ""
Then: end
If: q ne ""
Then: goto start
if:
Then: cls
If:   
Then: input fa(4,#,g) "From Client Number "
If:
Then: input fb(4,#,g) "From "<fa<"to number "
If:
Then: input ff(8,mdy/,g) "Enter 1st date"
If:
Then: input ll(8,mdy/,g) "From"<ff<"to what ending date"
If: fa eq "    " or fb eq "    " or ff eq "" or ll eq ""
Then: msgbox "No Report Created!";exit
If:
Then: input popup ("22","") q(1,yesno,g) "Is this correct? (Y/N)";cls
If: q ne "Y"
Then: msgbox "No Report Created!";exit
If:
Then: lookup -  k=ff    i=h -ng
start: If: 18 gt ll
Then: goto endit
If: 1 ge fa and 1 le fb
Then: select
If:
Then: end
endit: If:
Then: dl(8,mdy/,g)="12/31/79"
If:
Then: lookup - k=dl i=h -nl
If:
Then: end


scooter6 at gmail.com wrote:


I have output processing that asks the user for beginning client number,
ending client number, beginning action date and ending action date.
 
Recently it stopped working?
 
I have PFCMARK=80
 
the output looks like this:
 
If: fa=""
Then: input fa(4,#,g) "From Client Number "
 
If: fb=""
Then: input fb(4,#,g) "From "<fa<"to number "
 
If: ff=""
Then: input ff "Enter 1st date"
 
If: ll=""
Then: input ll "From"<ff<"to what ending date"
 
If: 18 lt ff
Then: lookup -  k=ff    i=h -ng
 
If: 18 gt ll
Then: dl(8,mdy/)="12/31/79"
 
If: 18 gt ll
Then: lookup - k=dl i=h -nl
 
If: 18 lt ff
Then: end
 
If: 18 gt ll
Then: end
 
If: 1 ge fa and 1 le fb
Then: select
 
This has worked for years but we recently upgraded to 5.6 and not it just
quickly ends, without selecting any records??
 
Any insight why that might be?
 
thanks
 
Scott
 
 
 
 
 
If: 18 lt ll
 


  _____  


_______________________________________________

Filepro-list mailing list

Filepro-list at lists.celestial.com

http://mailman.celestial.com/mailman/listinfo/filepro-list

  


  _____  



No virus found in this incoming message.

Checked by AVG - www.avg.com 

Version: 8.0.238 / Virus Database: 270.11.35/2034 - Release Date: 04/01/09
06:06:00



  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20090409/837f7e7e/attachment.html 


More information about the Filepro-list mailing list