1. Tracy Lamb
  2. PowerBuilder
  3. Tuesday, 5 October 2021 19:47 PM UTC

Hi Friends,

I've got a datawindow that I use for query... in my code, I stop after every 250 rows and ask user if they want to retrieve more.

I was editing the datawindow, and it automatically retrieves EVERYTHING... over 200,000 rows.  The message at the bottom of the dw designer window says "Press CANCEL to end retrieve"... I can't find the CANCEL button anywhere! 

Does anyone know where the CANCEL button is?


Accepted Answer
John Fauss Accepted Answer Pending Moderation
  1. Tuesday, 5 October 2021 20:02 PM UTC
  2. PowerBuilder
  3. # Permalink

H, Tracy -

I believe the "Retrieve" toolbar button doubles as the "Cancel" button during the auto-retrieve of the preview pane.

  1. Tracy Lamb
  2. Tuesday, 5 October 2021 20:21 PM UTC
Thank you!

  1. Helpful
There are no comments made yet.
Tracy Lamb Accepted Answer Pending Moderation
  1. Tuesday, 5 October 2021 20:28 PM UTC
  2. PowerBuilder
  3. # 1

You are right... the icon doesn't even change... and until the dw finishes retrieving, the dw doesn't show anything, so the RMB doesn't work.

The answer was given above... use the toolbar Retrieve button (even though the icon doesn't change) to cancel.



There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 5 October 2021 20:14 PM UTC
  2. PowerBuilder
  3. # 2

Hi Tracy;

   I see that this is a bug in both the DB Painter and the DW Painter - there does not seem to be a Cancel CB to press as per the message in the micro-help area.

   In the older PB IDE's, the Retrieve CB transformed itself into a "Cancel" while rows were still in progress. So the state of the Retrieve CB changed for that period. Interestingly enough, the Appeon PB IDE's Retrieve CB's state does change - its just that the CB's icon does not reflect the mode change into a cancel. However, the CB is in a cancel mode while Rows are Pending. So if you press the Retrieve CB while rows are in progress, you will see that the result set is canceled.    ;-)

   Please open a support ticket for this issue.

Regards ... Chris

There are no comments made yet.
  • Page :
  • 1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.