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

Click here to load this message in the networking platform