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
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
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
Low-carb diet not working? Try the Low-food diet instead!