>I suggest that you copy the table into a cursor, which VFP keeps in memory and/or a temp file depending on the amount of RAM you have. I also suggest that you update to VFP9, with VFP6 you have so many fewer possibilities.

>Select * from yourtable into cursor yourcursor nofilter

The select would take a lot of time writing the whole table 130MB app into a new file

There is nothing that VFP6 wont do what i need as to VFP9 (ofcourse Next ???? Unsure)


>If you want to make the cursor readwrite, you must use a trick in VFP6

>Select * from yourtable into cursor yourcursor nofilter
>select 0
>Use Dbf('yourcursor') Again
>use in yourcursor

>
>

suhas