# cancel grid fetch

**URL:** <https://forums.toadworld.com/t/cancel-grid-fetch/8955>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [November 10, 2009, 1:14pm UTC](https://forums.toadworld.com/t/cancel-grid-fetch/8955 "2009-11-10T13:14:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 10, 2009, 1:14pm UTC](https://forums.toadworld.com/t/cancel-grid-fetch/8955/1 "2009-11-10T13:14:13Z")

</div>

I noticed the ‘cancel’ button is disabled when I tried to do a Group  
function on a grid whose dataset was a 1,000,000 rows. My execute queries in  
threads is disabled, but I thought query execution was always a cancellable  
(sp?) event now…or am I mistaken?

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 10, 2009, 1:16pm UTC](https://forums.toadworld.com/t/cancel-grid-fetch/8955/2 "2009-11-10T13:16:47Z")

</div>

The automatic fetch caused by a group action is not cancellable. If you are  
unsure about how many rows you have, do a CTRL+End before your grouping, then  
you can cancel if needed.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 13, 2009, 2:28am UTC](https://forums.toadworld.com/t/cancel-grid-fetch/8955/3 "2009-11-13T02:28:05Z")

</div>

Unfortunately, I used the group function on a slow connection on a huge table: I  
had to close Toad by Taskmanager.

I’d really appreciate a cancel button in this situation!

Thanks,

Patrik

Von: [toad@yahoogroups.com](mailto:toad@yahoogroups.com) [[mailto:toad@yahoogroups.com](mailto:toad@yahoogroups.com)] Im Auftrag von John  
Dorlon  
Gesendet: Dienstag, 10. November 2009 20:17  
An: [toad@yahoogroups.com](mailto:toad@yahoogroups.com)  
Betreff: [toad] RE: cancel grid fetch

The automatic fetch caused by a group action is not cancellable. If you are  
unsure about how many rows you have, do a CTRL+End before your grouping, then  
you can cancel if needed.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 13, 2009, 7:30am UTC](https://forums.toadworld.com/t/cancel-grid-fetch/8955/4 "2009-11-13T07:30:19Z")

</div>

I’ve been working on it, and I did get it to be cancellable – sort  
of. The cancel worked, but it caused an error when I let the fetch  
complete. So, for now I have a warning that gives you a chance to cancel the  
grouping operation before the fetch. This will be in the beta.
