In this sample:
Create Cursor aaa (f1 c(2), f2 n(3))
Insert into aaa (f1, f2) values ( "f ", 1)
Insert into aaa (f1, f2) values ( "F ", 2)

I wish to do the navigate function for Top, Previous, Next and Bottom
through a table using Sql command but I found that it is very slow for the
following example when the table has more than 50,000 records:
Top:

Dear friends
my view statement
----------------------------
create sql view rorder_line_items as SELECT DISTINCT .F., Requestdtl.sl_no,

I have a couple of legacy FoxPro databases where production information
is still being written.  Currently this data is being moved to SQL
Server via a DTS package that takes several minutes to run.  I know I
can bulk insert very large files very fast, and I can output the FoxPro

I have a data set like:
Std Num    Date        Comment
111            6/29/06   Apple
111            7/29/06    Orange