Do you lose your pointer when the Retrieve starts or when it hits the RetrieveRow event?  I have never done anything exactly to what you are doing, but in other similar situations, I have seen PB revert the pointer during a process forcing me to programmatically reapply it within intermediate events.

Hi Andrew -

The pointer goes back to an arrow as soon as the retrieve starts, before retrieverow is hit. 

I am updating the question with one nuance... 

Thanks

My guess is the issue is somewhere in the DW Stored Procedure feature. I had a similar issue with Print().

Couple things to try though:

1) If you don't have this already, try adding the following to your PB.INI file (make sure you modify the correct one).

[DataStore Behavior]
UseHwnd=0

2) Can you make this retrieve work in a Shared Object instead?  Sounds like you are wanting this behavior anyway.

Chris Craft

There is an API that will lock the pointer until you UNlock it. SImply call the function to LOCK the pointer, then call the one to UNLOCK it when you are done.

// From a tab page on a tab on a window:

// Lock the pointer into an HourGlass
iw_parent.FUNCTION of_set_hourglass (TRUE)

// UNLOCK the pointer into an HourGlass
iw_parent.FUNCTION of_set_hourglass (FALSE)

I put the following function into corp_w_master:

// Local External Functions (on the window)

// OKnight, 26-AUG-2008, R#283713.
FUNCTION ulong   SetCapture(ulong a) LIBRARY "user32.dll"
FUNCTION boolean ReleaseCapture()    LIBRARY "user32.dll"

//*********************************************************************
// Object     :  corp_w_master
// Function   :  of_set_hourglass()
//
// Ancestor   :  None
// Access     :  Public
// Arguments  :  None
//
// Returns    :  None
// Throws     :  None
//
// Description:  Force the cursor to stay in the HOURGLASS shape.
//
//********************************************************************
// Revision History
//
// Developer    Date         Version     Description
// ---------   -----------   ---------   -------------------------------
// O Knight    28-NOV-2017   6.0.4.33    #2026345:  Implement new copyright.
// O Knight    26-AUG-2008   6.0.0.21    R#283713:  Initial installation
//
//********************************************************************
// COPYRIGHT © 2017 CSG SYSTEMS INTERNATIONAL, INC. AND/OR ITS
// AFFILIATES (“CSG”). ALL RIGHTS RESERVED.
//********************************************************************
ulong ll_handle, ll_rc



if (ab_switch) THEN
    ll_handle = Handle(this)
    ll_rc = SetCapture(ll_handle)
    SetPointer(hourglass!)
ELSE
    
    ReleaseCapture()
    
END IF

Hi Tom,

You can add the code below to the DataStore RetrieveRow event and see if it works:

SetPointer(HourGlass!)

Regards,

Ken