Remote View and CHeck state

[ryupb]

Hi,

I am trying to create an sql remote view from an sql server... this part is ok, but is there a way for me to check the state of the fetch??

You see, when I create a remote view programmatically the code runs smooth, but I need to know if all records has already been gathered or if the code is still executing...

anybody??

 

[JRB-Bldr]

Here is an example of code that I am using to determine when the Fetch has completed...

USE orders ALIAS orders IN 0  && Remote View into "Alien" DBC
SELECT orders
* --- Wait For ALL Records To Be Fetched ---
=CURSORSETPROP("FetchSize",-1,"orders")

* --- Check progress of Fetch ---
LabelHand = CURSORGETPROP("ConnectHandle","Orders")
DO WHILE SQLGETPROP(LabelHand,"ConnectBusy")
   =INKEY(3,"H")
ENDDO

* --- Fetch Complete Now ---
SELECT orders
INDEX ON agent_code + APPL TAG KEY
CURSORSETPROP('Buffering',5,'orders') && Set buffering to optimistic table
SELECT orders

Good Luck
JRB-Bldr