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


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

Re: ADO

Path csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: ADO
Date Mon, 2 May 2011 07:11:18 -0500
Organization Aioe.org NNTP Server
Lines 43
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>
NNTP-Posting-Host EJbh5qQXk5D/N9Qxnhwbqw.user.speranza.aioe.org
Mime-Version 1.0
Content-Type text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding 7bit
X-Complaints-To abuse@aioe.org
X-MimeOLE Produced By Microsoft MimeOLE V15.4.3508.1109
X-Notice Filtered by postfilter v. 0.8.2
X-Newsreader Microsoft Windows Live Mail 15.4.3508.1109
Importance Normal
X-Priority 3
X-MSMail-Priority Normal
Xref x330-a1.tempe.blueboxinc.net comp.lang.clipper.visual-objects:1019

Show key headers only | 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