Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1019
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: ADO |
| Date | 2011-05-02 07:11 -0500 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <ipm715$41b$1@speranza.aioe.org> (permalink) |
| References | <ipedl3$j3i$1@dont-email.me> <4dbb52d2$0$77724$c30e37c6@exi-reader.telstra.net> <iplmgc$f12$1@dont-email.me> |
Hey,
Here is some code that sets up for asynch operations. I hope that it helps
Regards,
Willie
BEGIN SEQUENCE
oRS := AdoRecordSet{}
oRS:CursorLocation := adUseClient
oRs:Properties:[Item,"Initial Fetch Size"]:Value := 500
oRs:Properties:[Item,"Background Fetch Size"]:Value := 500
oRS:Open(cSource, SELF:oConn, uCursorType, uLockType,
adCmdText+adASyncFetch)
DO WHILE _AND(oRs:State, AdStateFetching) != 0
// wait in this loop until the process is complete
Sleep(100)
IF lShowWait
// handle code to show a message to the user here with
progress
ENDIF
ApplicationExec(EXECWHILEEVENT)
IF _lcancel
BREAK "User aborted the Select"
ENDIF
ENDDO
IF lShowWait
// tear down any dialog that is showing the user messages about
progress
ENDIF
IF oRS:State = adStateClosed
oRS := NULL_OBJECT
ENDIF
ErrorBlock(cbErr)
RECOVER USING uError
ErrorBlock(cbErr)
// handle error message here
oRS := NULL_OBJECT
END SEQUENCE
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
ADO Eckhard Sallermann <eckhard.sallermann@bur-kg.de> - 2011-04-29 15:15 +0200
Re: ADO "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-04-30 00:07 +0000
Re: ADO "Willie Moore" <williem@wmconsulting.com> - 2011-04-29 21:43 -0500
Re: ADO "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-05-01 22:22 +0000
Re: ADO "Willie Moore" <williem@wmconsulting.com> - 2011-05-01 21:47 -0500
Re: ADO Eckhard Sallermann <eckhard.sallermann@bur-kg.de> - 2011-05-02 09:29 +0200
Re: ADO Eckhard Sallermann <eckhard.sallermann@bur-kg.de> - 2011-05-02 14:10 +0200
Re: ADO "Willie Moore" <williem@wmconsulting.com> - 2011-05-02 07:11 -0500
Re: ADO Eckhard Sallermann <eckhard.sallermann@bur-kg.de> - 2011-05-02 14:27 +0200
Re: ADO "Willie Moore" <williem@wmconsulting.com> - 2011-05-03 07:56 -0500
Re: ADO "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-05-02 21:55 +0000
csiph-web