Move pointer of a table to last record

Is there any way to move the pointer of a table to last record apart of 'go bottom' func.

Regards

Ahsan

It does not make much sense. GO BOTTOM goes to the bottom record in logical order (i.e. depending on current sort order).

[Update] I forgot to mention what is mentioned below in other responses that it is dependent on index and filters, therefore in many cases though being the easiest, it is not the fastest (in case on using filters this could be significant).

Yes of course there a lot of ways to move the pointer to the last record w/o using "go bottom". One of them is on purpose so I assume you're asking that one.

"Go Bottom" is not Rushmore optimized (in VFP9 I doubt it's not) and therefore you could use an existing index created purposefully for such thing. ie:

index on 1 tag myLocator && created once

And execute a go bottom using that index:

set order to tag myLocator descending

locate

Yes. If index is on, go bottom might not go to the last record (physically.)

Select yourTable

Set order to

Go bott

OR (with Index on)

Select yourTable

lnLast=recc()

go lnLast

Well, another way would be

select myTable

locate for .f.

eof()

CetinBasoz wrote:

"Go Bottom" is not Rushmore optimized (in VFP9 I doubt it's not) and therefore you could use an existing index created purposefully for such thing. ie: index on 1 tag myLocator && created once And execute a go bottom using that index: set order to tag myLocator descending locate

This is from Andy's white paper from a session he gave when VFP 7 first came out on optimizing VFP:

Locate vs Go Top

One of the conventions that has passed into FoxPro mythology is that a LOCATE command is faster than using GO TOP, and that by reversing the index order on a table and using LOCATE performance is better than just using the GO BOTTOM command. However, as the following table shows, this is only true when you are using Filters and is more to do with the fact that the LOCATE command is optimizable (as shown above) than anything else. In VFP 7.0 the difference between the two commands is smaller than in previous versions anyway. Of course, GO TOP and GO BOTTOM retain one huge advantage over LOCATE because they can take an IN <alias> clause, thereby obviating the need to change work areas.

Marcia,

Results show me that "Go Bottom is slower" is not a myth but a fact. However I wouldn't bother with the difference myself.