Hi!

You may try to use non-batch asynchronous mode. However, with remote views I don't know if you will be able to get correct work. With SPT you will get a set of cursors which you than require to link together into a single cursor. I never tried that approach, I refer to VFP Programmer's Guide, Chapter 21: Implementing a Client/Server Application, 'Processing Multiple Result Sets'.

>I would like to be able to update a progress bar with the status of a SPT statement. The data is on SQL Server being accessed via ODBC. We are using Remote Parameterized Views but of course don't want to / can't bring down the whole table to perform functions locally but have to show the status of the Select, Update, Delete.
>
>I've looked at getting @@rowcount and from SQL Server but that returns the total affected and only executes after the previous statement is done.
>
>@@cursor_rows returns the number of rows currently in the keyset but again, only executes after the previous statement has completed.