Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #1019

Re: ADO

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>

Show all headers | View raw


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


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