Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #989
| 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) |
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
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