I want to append from an SQL table into a local DBF

If I do this:
open database mydbc
sele 0
use SQL_table_remote_view
sele 0
Use Mydbf
append from dbf("SQL_table_remote_view)

It will append ZERO records


If I do THIS:
open database mydbc
sele 0
use SQL_table_remote_view
Browse &&wait until the entire table loads
sele 0
Use Mydbf
append from dbf("SQL_table_remote_view)

It will append ALL of the records

How do I make Foxpro wait until the SQl table is loaded?


VFP 8 SP1 MS SQL 2000