Hi,
run this code in VFP6SP5,VFP7SP,VFP8.
CREATE CURSOR TEST (n I)
nCycle=100000
FOR I=1 TO m.nCycle
INSERT INTO TEST (n) VALUES (RAND()*m.nCycle)
NEXT
INDEX ON n TAG nix
? RECCOUNT()
SELECT * FROM TEST WHERE n>100 INTO CURSOR Filtered
? RECCOUNT(),_TALLY,FILTER()
On VFP6SP5 Filtered is a filtered cursor of test,
then any changed on TEST is see on Filtered.
On VFP7SP,VFP8 Filtered is a table cursor,
like if you use NOFILTER clause,
and changed on TEST is not see on Filtered,
then any old program can change result randomly.
Is it a new behaviour of VFP7 and VFP8 ?
I can't found documentation on this.
Never surprise, it is normal for VFPT change function without document it.
Fabio