Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PROBLEM: SELECT result can change with index
Message
From
05/09/2003 08:53:24
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
PROBLEM: SELECT result can change with index
Miscellaneous
Thread ID:
00826364
Message ID:
00826364
Views:
60
Hi,

on SELECT i can have not equal result if i have or not have a index.
CREATE CURSOR myCur (f1 c(2))
INSERT INTO  myCur VALUES ('A ')
SELECT * FROM myCur WHERE f1=='A  '
SELECT myCur
INDEX on f1 TAG tag1
* Next line:
* On VFP6SP5/VFP7SP1 it found record
* On VFP8 it not found record
SELECT * FROM myCur WHERE f1=='A  '


Fabio
Next
Reply
Map
View

Click here to load this message in the networking platform