Weird output with associated field

Boaz Bezborodko boaz at mirrotek.com
Mon Jan 28 14:18:20 PST 2008


There are no indexes on the associated fields. 
The entire selection part of the routine looks like this
38  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ? If: 20 ge ba and 20 le bb and aa="" and 19 ne "AD"
      Then: SELECT
(The associate fields are 41 through 50.)

I removed the indexing commands to sped up the selection and go through 
the entire file, but that doesn't change anything.  I go through it with 
"debug" and verify that the record is being selected and even that the 
record is being processed during the output processing and that this 
happens on the associated record.  (I used a break condition on the 
specific field equaling the data that I was looking for and it stopped 
there and I verified that this was the correct record.  There is nothing 
in the output processing that would drop any record.)  But the data is 
not printed and totals don't include it.

This is really bothering me because I can't find anything in my 
processing which would cause the problem.

Boaz


Jeff Harrison wrote:
> --- Boaz Bezborodko <boaz at mirrotek.com> wrote:
>
>   
>> I'm having trouble with a report.  I'm re-running an
>> accounting report 
>> that someone ran a week and a half ago, but I'm
>> getting a strange 
>> result.  One of the items in an associated field is
>> not being printed.
>>
>> Each record can store a few GL numbers in associated
>> fields A1.  The 
>> report selects the records by invoice date and sorts
>> them by A1.  The 
>> report that was run over a week ago seems to have
>> everything correct, 
>> but the report I'm running today has the associated
>> field missing on 
>> just one record.  Other records with associated
>> fields print out properly.
>>
>> I have the exact same problem with 3 other records
>> that are exactly the 
>> same in different months.  (They are monthly
>> insurance payments 
>> allocated to two different GL #s.)  For some reason
>> the second 
>> associated field on them also don't appear on the
>> reports for their 
>> respective months. 
>>
>> The records haven't been touched in between the runs
>> and the only change 
>> was indexing the selection to speed it up.  But the
>> records are 
>> definitely getting selected since the first
>> associated field appears on 
>> the file.  And the report is definitely printing
>> associated fields since 
>> other records with entries in the multiple
>> associated fields are 
>> displaying correctly.
>>
>> What is causing this and how do I fix it?
>>
>> Boaz
>> _______________________________________________
>>     
>
> Hi Boaz.  It is hard to answer this question without
> knowing the specifics of exactly what you are doing
> for sort/selection.  What does the -v table look like,
> what do the sort fields look like on the report?  What
> auto indexes do you have?  What does the selection
> table look like?
>
> A telling statement of yours was:
> ...
>   
>> and the only change 
>> was indexing the selection to speed it up. 
>>     
>
> Can you give more specifics here?
>
> Jeff Harrison
> jeffaharrison at yahoo.com
>
> Author of JHExport and JHImport.  The fastest and
> easiest ways to generate filepro exports and imports
>
>
>
>       ____________________________________________________________________________________
> Be a better friend, newshound, and 
> know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20080128/994426e8/attachment.html 


More information about the Filepro-list mailing list