When I used SQLNET v1.x with Powerbuilder v4.x, I was able to stop a
datawindow retrieve in my apps with a key combination of <CTRL>-<C>. This
was a very nice feature to have, especially, with a datawindow retrieval
lasting several
minutes.
With Powerbuilder v5.0.0.3 and SQLNET v2.0, the <CTRL>-<C> feature does not
work. Powersoft tech support says that Oracle SQLNET v2.0 does not support
this feature. But, SQLNET v2.0 documentation says that it does support this
feature. I tested this successfully via SQLPLUS.
I could use the RetrieveRow datawindow event to check for a user
cancellation of the retrieval, but as most Powerbuilder users know, using
the RetrieveRow event slows the retrieval process down dramatically.
So, I began thinking about other ways to provide this functionality. My
first thoughts concerned how Powerbuilder uses a stop button (red hand)
during datawindow previewing to stop a retrieval. This button does not
appear to slow down the retrieval process as with the RetrieveRow event, but
it does provide the developer with a simple means of stopping the retrieval.
Just what I'm looking for!!!
Powerbuilder does not provide any powerscript functions to mimic this stop
button; however, I would think that an API call to a powerbuilder DLL would
be
available to perform the function of the stop button. Does anyone know of
such an API call?
If so, I would like to know the details of such a call.
Thanks!!!
Bryan McFarland
:)