Selection Logic - Windows 2003 filepro 5.0

Nancy Palmquist nlp at vss3.com
Mon Apr 2 13:01:59 PDT 2007


Bruce Easton wrote:
> Please see inline comments/questions...
> 
> Nancy Palmquist wrote Monday, April 02, 2007 3:31 PM:
> 
>>[..]
>>We have a scan select process that runs successfully from beginning to 
>>end - no errors.  It picks what seems to be the right number of records 
>>which it is then supposed to copy to selected files in the output step. 
>>I know it picks the right number of records because I count them and 
>>display the totals in the @done logic when all is supposed to be done.
>>
>>So if the source file has 40,000 records, I should end up with close 
>>40,000 records total in the files it writes.  These start blank and I 
>>said close to because there is some logic to eliminate records that are 
>>not billable.  (Might be 10 or 20 like that)
> 
> 
> Are there any indexes that are used for this filtering?  Maybe the
> indexes on one side are corrupt (or just different)?
> 

Indexes are not at issue - as far as I would expect.  I am not missing 
the records by not selecting them, I am selecting them, I am processing 
them on output side where records are generated for each record.  I am 
missing these records, and not just one or two, I am missing thousands 
of records.


> 
>>When it breaks I might be missing 3000 records - a significant 
>>difference.  We clear the files and run it from the Win2000 and it runs 
>>flawlessley with all records copied successfully.
>>
>>It has done this twice now.  The process has been running without issue 
>>for years and now two months in a row we have had to rerun it repeatedly 
>>to get all the records correctly copied.
>>
>>The two computers use the same config file - so index scan is not 
>>different.
>>
> 
> 
> How do you mean?  Based on setting of PFCMARK?
>  
> 
>>[..]
> 
> 
> Bruce
> 
> Bruce Easton
> STN, Inc.
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 


-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com


More information about the Filepro-list mailing list