I have a view and I am doing a scan to pick up data from another table. Seems that as the process is keeping the relationship for the first 2 records and then the pointer in the related table does not change.
Here is the code:
Sele lv_master2_config
Requery()
Set RELATION TO sono INTO Somast01 ADDITIVE
scan
replace sodate with ctod(somast01.sodate), ponum with Somast01.ponum,;
shipvia with Somast01.shipvia, cshipno with somast01.cshipno
endscan
This is how the data should look: (set stp on produces this)
Record# SONO CSHIPNO PONUM
1 21705 4025 BU639-4025
2 21709 1459 AF298-1459
3 21710 1554 AA949-1554
But this is what I get in end user mode:
Record# SONO CSHIPNO PONUM
1 21705 1459 AF298-1459
2 21709 1459 AF298-1459
3 21710 1459 AF298-1459
4 21704 1459 AF298-1459
5 21708 1459 AF298-1459
When you have the two tables open and watch the relation as teh parent table changes, when done slowly it looks fine. But mash down that down arrow and you don't see the child table changing at all.
I have done a reindex on the child table.
This is a new one on me. Is it something to do with buffering?