Message
From
17/07/2003 11:37:56
 
 
To
17/07/2003 11:17:54
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00811089
Message ID:
00811108
Views:
18
>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 just tried this, and I see the expected behavior in all three versions.

Are you sure your settings are the same? Make sure DELETED is OFF.

Tamar
Previous
Reply
Map
View