Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Cancel retrieve in DW

  1. How-to
0
Votes
Undo
  1. Tracy Lamb
    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?

TIA,
~~~Tracy

  1. DataWindow
  2. Retrieve
Migration Power Builder
Hide computed field if text exceeds height
Accepted Answer
John Fauss
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.

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

  1. Helpful
There are no comments made yet.
Responses (3)
Tracy Lamb
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.

~~~Tracy

 

Comment
There are no comments made yet.
Chris Pollach @Appeon
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

Comment
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.