Visual Nonblocking Mode

jfudickar · Post by **jfudickar** » Mon 07 Aug 2006 08:28

Hi,

is something a visual nonblocking mode possible:

I want to show the duration of statement execution, how much records are fetched, and i want to implement a messagebox which asks every x Records if the fetch should be continued.

Greetings and thanks
Jens

Challenger · Post by **Challenger** » Tue 08 Aug 2006 13:22

OraQuery doesn't have event handlers that allow to gather information you need when Nonblocking mode is on. You can get all this information by monitoring Executing, Fetching, FetchingAll and RecordCount properties in the separate thread.

jfudickar · Post by **jfudickar** » Tue 08 Aug 2006 14:26

And is there a way to cancel the execution after for examples 5000 records fetched?

Challenger · Post by **Challenger** » Fri 11 Aug 2006 09:34

No, you can not do this. Another way is to create your own thread, which will control execution and fetching process.

jfudickar · Post by **jfudickar** » Thu 17 Aug 2006 06:48

Sorry, what do you mean?

Yust for info: I'm working on such an implementation and it will be included in the jvcl.

Greetings
Jens