Welcome! Log In Create A New Profile

Advanced

[WD12] Use of hQueryBreakable

Posted by Louis Verbraak 
Louis Verbraak
[WD12] Use of hQueryBreakable
February 02, 2009 09:41AM
Hello,

Can anybody tell me how to use 'hQueryBreakable' in HExecuteQuery and HExecuteSQLQuery. I hoped I could break the query by pressing <ESC> but there is no reaction or I get a Windows-error (Tell microsoft...). Is there a way to catch the <ESC> and let the user confirm the aborting or let the query continue?

I hope I made myself clear.
BLS
Re: [WD12] Use of hQueryBreakable
February 03, 2009 12:04PM
I would place the HExecuteXXX call within an exeption to get more information.
likewise:
WHEN EXCEPTION IN
HExecuteXXhot smiley)
DO
//Code used to process the exception
Error( ExceptionInfo(errCODE) )
ExceptionEnable()
END

to figure out what's going on.

HTH Björn L-S.
BLS
Re: [WD12] Use of hQueryBreakable
February 03, 2009 12:12PM
IF you are using HF /CS .... THEN this parameter is not available:


Björn L-S.
Louis Verbraak
Re: [WD12] Use of hQueryBreakable
February 03, 2009 01:11PM
Hello Björn,

Thanks for your answer. Unfortunately this is, as far I can see, not solving mine problem. The HExecuteXXX runs a query and comes back with the result of with an error. You are right, it is possible to trap that error. But I need a way to abort the execution of a query by pressing <<Escape>> AND I want the <<Escape>> to be confirmed before realy stopping the query or continue the query.

Should I start the query in a thread or is there another way of doing this?
Bart Van der Elst
Re: [WD12] Use of hQueryBreakable
February 03, 2009 03:49PM
Pressing the Esc key abort the execution of the query
I'm still using good old WD8
Louis Verbraak
Re: [WD12] Use of hQueryBreakable
February 03, 2009 04:48PM
Hello Bart,

Is it? And if so, can I prevent that or better can I continue the query after a confirmation?
Bart Van der Elst
Re: [WD12] Use of hQueryBreakable
February 03, 2009 05:10PM
Hello Louis,

I don't think so. Pressing Esc aborts the query immediately.

Kind regards,
Bart
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: