Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
PROBLEM: SELECT result can change with index
Message
 
 
À
05/09/2003 10:05:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00826364
Message ID:
00826410
Vues:
19
Sorry Fabio, but I don't understand what your code shows.

>Hi Sergey,
>
>yes, it depends on the INSERT history sequence, and by the found string.
>
>
>CLEAR
>CLEAR
>SET DELETED ON
>CREATE CURSOR myCur (f1 c(2))
>INDEX on f1 TAG tag1
>INSERT INTO  myCur VALUES ("A ")
>SELECT * FROM myCur WHERE f1 == "A  " INTO ARRAY pippo
>IF _TALLY=0
>  ? RECCOUNT(),f1
>ENDIF
>INSERT INTO  myCur VALUES ("A ")
>SELECT * FROM myCur WHERE f1 == "A  " INTO ARRAY pippo
>IF _TALLY=0
>  ? RECCOUNT(),f1
>ENDIF
>* ...
>* while insert A you cannot find
>* now ...
>INSERT INTO  myCur VALUES ("B ")
>SELECT * FROM myCur WHERE f1 == "A  " INTO ARRAY pippo
>IF _TALLY=0
>  ? RECCOUNT(),f1
>ENDIF
>INSERT INTO  myCur VALUES ("B ")
>SELECT * FROM myCur WHERE f1 == "A  " INTO ARRAY pippo
>IF _TALLY=0
>  ? RECCOUNT(),f1
>ENDIF
>INSERT INTO  myCur VALUES ("A ")
>SELECT * FROM myCur WHERE f1 == "A  " INTO ARRAY pippo
>IF _TALLY=0
>  ? RECCOUNT(),f1
>ENDIF
>* etc
>
>
>It is correlate with the index history.
>
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform