Could this be a bug in FilePro? (Was--Weird output with associated field)
Boaz Bezborodko
boaz at mirrotek.com
Tue Jan 29 18:27:25 PST 2008
OK, I found out that the problem occurs when I use indexing to go
through the sort/selection processing to speed up the operation and that
it only occurs when this particular record is the first to appear in the
selection set in the index. If I change the selection set to start on a
day before, or I change the date field in the record so that it is a day
later, (IOW if the record is no longer the first to be selected) then
both associated fields appear correctly on the report. (BTW, if I added
more data to the other associated fields they also wouldn't show.) But
anytime it is the first record to be selected then only the first
associated field appears. This is true for 3 other records that are
identical to the first, but for 3 other months. In all cases the records
appear as the first in the indexed selection set.
I also tried this with other records that have more than one entry in
associated fields that would be the first in the indexed selection set.
In all cases only the first associated entry is displayed and all others
are missing.
Either I am doing something wrong (And I can't see where I am--though
I'm not as experienced as the rest of you) or there is a fundamental bug
in the way FP is working. (I'm using version 5.6.06D9.)
I execute rreport with a -io ('o' index is on the invoice date field
'20'). I then ask for the beginning date (dummy field 'ba') and ending
field ('bb'). I then use this to jump to the first record:
32 ------- - - - - - - - - - - - - - - - -
◄ If: ◄
Then: lookup - k=ba i=O -bg ◄
The selection processing then looks like this:
33 ------- - - - - - - - - - - - - - - - -
◄ If: ◄
Then: ai(10,mdyy/,g)="12/31/2050" ◄
34 ------- - - - - - - - - - - - - - - - -
◄ If: '--------------------------------------------------------- ◄
Then: ◄
35 ------- - - - - - - - - - - - - - - - -
SELECT ◄ If: 20 gt bb ◄
Then: lookup - k=ai i=O -bg ◄
36 ------- - - - - - - - - - - - - - - - -
◄ If: ag ne "" and ag ne 17 ◄
Then: END ◄
37 ------- - - - - - - - - - - - - - - - -
◄ If: MID(30,"1","13") eq "Keyoffs check" 'Keyoff checks should not be>
Then: END ◄
38 ------- - - - - - - - - - - - - - - - -
◄ If: 20 ge ba and 20 le bb and aa="" and 19 ne "AD" ◄
Then: SELECT ◄
This selects every record with '20' within 'ba' and 'b'. Even the record
I'm missing gets selected for the first associated field in the record.
But the second associated field never shows up even though other records
with something in the second associated field get printed.
The Sort for the output file looks like this.
┌─────────────────────────────── Field list ──────────────────────────────┐
│ 1- VENDOR NAME (RANDOM 11- CHECK NUMBER (ALPHA 21- due date │
│ 2- address 1 (r 12- VOUCHER NUMBER 22- address line 3 │
│ 3- address 2 (r 13- discount base 23- VENDOR NAME (RECENT │
│ 4- city 14- terms (days) 24- date units received │
│ 5- state 15- discount (days) 25- sales tax code │
│ 6- zip 16- discount percent (% 26- taxable amount │
│ 7- code for memo 17- VENDOR NUMBER 27- remarks │
│ 8- CHECK NUMBER (NUMER 18- invoice amount 28- date posted │
│ 9- date paid 19- invoice or debit me 29- customer ship-to (f │
│ 10- CHECK AMOUNT 20- invoice date 30- INVOICE NUMBER │
└─────────────────────────────────────────────────────────────────────────┘
=A2
┌────────────────────────── Sort definition ────────────────────────┐
│ │
│ Sort Field: 61 ◄ A1)◄ 1 ◄ 28 ◄ 9 ◄ ◄ ◄ ◄ │
---│ Length: 0◄ 5◄ 30◄ 8◄ 8◄ ◄ ◄ ◄ │
│ Descending: ◄ ◄ ◄ ◄ ◄ ◄ ◄ ◄ │
│ Subtotal Field: f◄ x◄ x◄ ◄ ◄ ◄ ◄ ◄ │
│ │
le:└──────────────────────────Press ESC To Record, Ctrl-C To Cancel┘ETD
Press F10 for help
And the output looks like this:
!@td
!@tm P U R C H A S E J O U R N A L
*ba - *bb
V E N D O R INVOICE NUMBER DATE REC'D DATE POSTED DATE PAID AMOUNT R E M
A R K S
===============================================================================
D A T A L I N E S
*1 *30 *24 *28 *ae*9 *A2 *ad
_____________________________T O T A L L I N E
S______________________________
SUBTOTAL BY VENDOR NAME (RANDOM) INDEX E
SUBTOTAL BY A1) GL NUMBER 1
*A1 *ab
As far as I can tell everything looks kosher. What am I missing?
Boaz
More information about the Filepro-list
mailing list