Mensaje
De
17/07/2003 11:17:54
 
 
a
Todos
General information
Foro:
Visual FoxPro
Category:
Título:
NOFILTER on SELECT is implicit ?
Miscellaneous
ID de la conversación:
00811089
ID del mensaje:
00811089
Views:
53
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
Next
Responder
Mapa
Ver