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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.