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