Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
PROBLEM: SELECT result can change with index
Message
De
05/09/2003 10:05:37
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00826364
Message ID:
00826401
Vues:
20
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.

Fabio
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform