I apologize if I missed this in the documentation.  I haven't been able to figure out how to determine if a LoadRows is in process and whether or not the request can be canceled.

Any help is highly appreciated!  Thank you

Best regards,
Allen

See TDatabase component Help.

- NumPendingRequests
- CancelPendingRequests

See last paragraph here:

https://www.elevatesoft.com/manual?action=viewtopic&id=ewb2&topic=Creating_Loading_DataSets

Walter

Allen W. Hunt wrote:

I apologize if I missed this in the documentation.  I haven't been able to figure out how to determine if a LoadRows is in process and whether or not the request can be canceled.

Any help is highly appreciated!  Thank you

Best regards,
Allen

<< See last paragraph here:

https://www.elevatesoft.com/manual?action=viewtopic&id=ewb2&topic=Creating_Loading_DataSets >>

Hi Walter,

I tried checking NumPendingRequests  by using a timer and it never showed any request even though I had a select executing.  I did CancelPendingRequests  while the LoadRows was running and I got a message there are no pending requests.

Maybe it has something to do with me setting AutoTransactions to True.  I'll try starting the transaction manually and see what happens but I thought it pertains to inserts, updates, and deletes only (so that Rollbacks or Commit can be performed).

I suppose it could have something to do with me using an older version of EWB version 2.14 Build 5.

I'll let you know what I find out.  Thank you very much!

Best regards,
Allen

Once you Execute the LoadRows - there would be 0 PENDING - pending would only be if you did several and they had not finished.

When you start LoadRows and it is sent to server and  running you cannot cancel - you sent the request to the server - this is not a desktop application.  There are two different computers (unless you are really clever and can send a command to server to stop and know what thread  is doing the work...)

You either wait for an OnError or OnLoad to determine the outcome.

You need to do Web programming statelessly.

Walter


Allen W. Hunt wrote:

<< See last paragraph here:

https://www.elevatesoft.com/manual?action=viewtopic&id=ewb2&topic=Creating_Loading_DataSets >>

Hi Walter,

I tried checking NumPendingRequests  by using a timer and it never showed any request even though I had a select executing.  I did CancelPendingRequests  while the LoadRows was running and I got a message there are no pending requests.

Maybe it has something to do with me setting AutoTransactions to True.  I'll try starting the transaction manually and see what happens but I thought it pertains to inserts, updates, and deletes only (so that Rollbacks or Commit can be performed).

I suppose it could have something to do with me using an older version of EWB version 2.14 Build 5.

I'll let you know what I find out.  Thank you very much!

Best regards,
Allen