Details

All HTTP queries should include a Transaction ID. The Transaction ID is a random generated number with an epoch tag (a time number to make is unique). The server-side script should store the Transaction ID along with a status code (in process, cancelled, error, completed, etc.). Then, the client application can query the server-side script for the Transaction ID to check if the prior query was completed or not.

This is to improve the robustness of the OSCPMWin application when using the new HTTP-SQL connection functions.

The current experimental implementation assumes the queries were sent without error over the HTTP connection. However, over unreliable network links, the HTTP connection can be dropped and then the requested query would not be executed.

Or we can concatenate the ID and epoch:
TranID : BIGINT(16)
TranStatus : INT(4)

We can even just assume the state has just two values: TRUE or FALSE (true is completed, FALSE is not completed). If the record is missing then it means the transaction was not received at all or it contained fatal errors.

The client application should retry if the status remain FALSE, or just assume the transaction has failed.