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


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

ADO

From Eckhard Sallermann <eckhard.sallermann@bur-kg.de>
Newsgroups comp.lang.clipper.visual-objects
Subject ADO
Date 2011-04-29 15:15 +0200
Organization A noiseless patient Spider
Message-ID <ipedl3$j3i$1@dont-email.me> (permalink)

Show all headers | View raw


VO 2.8 SP3
VO2ADO 2.8 ( AdoSetAdoVersion() = 20 , AdoVersion() = 6.1 )
Windows 7 64 bit
MS-SQL-Server 2008 R2



code for getting data from SQL-Server:

     lOk := true
     begin sequence
         cbErr := ErrorBlock({|e|_Break(e)})
         oAdoRecordSet := AdoRecordset{}
         oAdoRecordSet:open( csql , _oAdoConnectionMSSQL1 , 
adOpenKeyset , AdLockReadOnly , adAsyncExecute  )
         WHILE true
             IF oAdoRecordSet:state = 1
                 exit
             ENDIF
             Sleep(100)
             ApplicationExec( EXECWHILEEVENT )
             if _lcancel
                 exit
             endif
         ENDDO
         lOk := true
     recover using oError
         MyMessBox( nil , Token( ExecName(FALSE) , "." , 1 )  , 
{     "Fehler bei Selektieren der Buchungen: " + csql , 
oError:description  } , BOXICONEXCLAMATION     + BUTTONOKAY) 

       lOk := FALSE
            _lcancel := true
     end
     ErrorBlock(cbErr)




     if lOk .and. !_lcancel
         oAdoServer := AdoServer{ oAdoRecordSet , ;
                 _oAdoConnectionMSSQL1 ,  ;
                 adOpenKeyset , ;
                 AdLockReadOnly   , ;
                  adCmdTable + adAsyncExecute } //
         oAdoServer:nullasblank := true
         oAdoServer:gotop()
         IF !oAdoServer:eof

                    . . . . .
The loop after oAdoRecordSet:open() runs until getting 1 from 
oAdoRecordSet:state, but this happens to fast and initializing AdoServer 
takes the time, that it takes as running on SQl-Server-Management 
Studio, but the Vo app is frozen until AdoServer{} gets ready.



what im i doing wring here ?

Back to comp.lang.clipper.visual-objects | Previous | Next — 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