Hi there,

I'm doing some conversion work from dbf's into a sql server database.

One of the things I'm doing is populating a remote view with Table Buffering (buffering = 5).

Before issuing the tableupdate() to commit the data from the remote view into the sql-server table, I need to populate an additional cursor with this uncommited data.

For example:

use test_rv &&This is the remote view
append blank
replace name with "Alex", phone with "201-656-0132"
append blank
replace name with "Alex", phone with "201-656-1979"
append blank
replace name with "Susy", phone with "201-659-3300"

select distinct name from test_rv into cursor people_cu

* Do something else

select test_rv
tableupdate(.t.)

Under the above scenario, cursor temp_cu comes up empty.

I could work around it (and for the time being will do so), but am wondering if there is any way to get the data from a remote view into another cursor prior to committing the data to sql-server.

Thanks!

Alex