Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Go lnRec
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00961543
Message ID:
00961546
Views:
12
Mike,
GO TOP & GO BOTTOM use index, but GO nRecNo doesn't position the marker to relational Record Number but the exect one.

>In the help file it specifies that GO BOTTOM uses an index, I would think that they all do.
>
>BOTTOM
>Positions the record pointer on the last record in the table. If the table has an ascending index in use, the last record is the record with the highest key value. If the index is in descending order, the last record is the record with the lowest key value.

>
>>Hello all.
>>My co-worker and I have a bet that we would like for you all to help settle.
>>
>>When "Go MyRecordNo" is issued, is there an internal index at work to find the record?
>>
>>Thanks.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform