>In Visual Fox, to move from one row to another in a table ordered by an index you have to move the pointer within the table. In this way you can move quickly within the table using the PG-Up and PG-Down keys.
> How can you simulate this in a MySQL database using SQL syntax(using ORDER BY with LIMIT it runs slow)?
>
>Thanks,
Basically, when you access to a database server, some changes in methodology are appropriate. You can create a view that will fetch an entire tables, but for large tables, this will be slow - all the data has to be copied over the network. Therefore, you should not try, for example, to do the equivalent of USE MYTABLE followed by GO BOTTOM.
You will have to get small pieces of data at a time. You can create remote views with parameters, which get data for a specific client, salesperson, date, etc. The user will have to specify criteria before fetching the data.
With a remote view, the data will be fetched into a cursor. Once you have this cursor, you can use it just as you would use any VFP table.
Other alternatives, instead of remote views, include SQL pass-through, and CursorAdapters.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)