>First item here?
http://fox.wikis.com/wc.dll?Wiki~RemoteViewFAQ~WikiInteresting. I wish there was simply a way to change the fetchsize to avoid the problem to begin with...but I don't see a way to do that..perhaps there is?
I wish I could reproduce the error on my dev machine..I feel like I'm shooting in the dark here. Anyway this is what I was going to try..
*-----------------------*
* Execute SQL statement *
*-----------------------*
lnEResult = SQLEXEC(plnConnectionHandle, lcSQL, tlcOutputCursor, aCountInfo)
*------------------------------*
* Checking for busy connection *
*------------------------------*
IF USED(tlcOutputCursor)
SELECT (tlcOutputCursor)
GO BOTTOM
ENDIF
lnWaitCounter = 1
Do While SQLGetProp(plnConnectionHandle,"ConnectBusy")
*-------------------------------*
* Wait one sec, hide the cursor *
*-------------------------------*
lnWaitCounter = lnWaitCounter + 1
WAIT WINDOW 'Attempting DB2 data pull...' + ALLTRIM(STR(lnWaitCounter)) NOWAIT
=Inkey(1,"H")
ENDDO
IF USED(tlcOutputCursor)
SELECT (tlcOutputCursor)
GO TOP
ENDIF
I have idea if it will work or not but it seems like it should. Based on what I"ve seen it never pulls more than 60 records ..its a small dataset so I don't see why the fetchsize would even matter...soooo strange.
ICQ 10556 (ya), 254117