Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek, seek(), indexseek()
Message
From
05/09/2002 07:27:38
 
 
To
04/09/2002 18:21:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00696857
Message ID:
00696998
Views:
9
>Certainly your solution is very useful in most cases, but what if I decided
>to move to the record in case is found? what I wanted is your solution but in one indexseek()

In that case, juse LOCATE:

SELECT TheTable
LOCATE FOR FieldA = "ValueA" AND FieldB="ValueB" ;
AND FieldC="ValueC"

As long as you have indexes for FieldA, FieldB, and FieldC, the command will be optimized.

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform