Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PROBLEM: SELECT result can change with index
Message
 
 
To
05/09/2003 10:05:37
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00826364
Message ID:
00826410
Views:
20
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform