|
| WD How to interrupt a process . . . |
| Iniciado por guest, 15,dic. 2017 01:39 - 4 respuestas |
| |
| | | |
|
| |
| Publicado el 15,diciembre 2017 - 01:39 |
I updating a MS SQL database from a Query.
The process runs perfectly!
Occasionally while running the update procedure I need to stop it.
But I have not found the function or instructions to make that happen.
Can anyone give me a hint?
THNX !!
Joe Maldo |
| |
| |
| | | |
|
| | |
| |
| Publicado el 15,diciembre 2017 - 11:49 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 15,diciembre 2017 - 17:12 |
Thank you for your reply. However, this is a WinDev Query that is running and, from that query I am updating a MS SQL from WinDev.
So, I need a WinDev function that will do the trick . . .
This is the code that I am running from WinDev:
==============================================================
FOR EACH QRY_IMP_BOSS
// Displays the Stop Button while the data load is happening
BTN_StopProcess..Visible = True
HReadSeek(Values,Keys and Other Stuff)
IF HFound() THEN
CONTINUE
// The user preses a button on the screen to set this value to TRUE
// my problem is that the button is displayed but does not work during the update process . . .
IF bProcess_Stop = True THEN
BREAK
Info("Procedure Terminated by user . . . ")
BTN_StopProcess..Visible = False
END
ELSE
Destination.Fields = Source.Fields
HAdd(BVS_BOSS_LOAD)
END
nPBProcVal += 1
STC_Proc_Count = nPBProcVal
PROGBAR_Status = nPBProcVal
WinRedraw(WIN_Load_RAW_DATA)
END |
| |
| |
| | | |
|
| | |
| |
| Publicado el 15,diciembre 2017 - 18:24 |
Hi
Try to add
multiTask(-1) after "FOR EACH QRY_IMP_BOSS"
to see if it works
HTH
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 15,diciembre 2017 - 19:02 |
Hi again
it's NOT a windev query... It's a query run on a MSSQL DB by windev (ie windev is sending the query to MSSQL, MSSQL is doing the work, then giving the results back to windev)...
As such, the ONLY way to interrupt the process while it is running on the MSSQL server is to ASK MSSQL to stop it, and that is what is described in the URL I gave you.
as for the answer by King, it won't do anything, as the query is run ON THE SERVER, in its entirety, before the first iteration in the for loop.
Best regards |
| |
| |
| | | |
|
| | | | |
| | |
|