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


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

Re: ADO

From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: ADO
Date 2011-04-29 21:43 -0500
Organization Aioe.org NNTP Server
Message-ID <ipft17$7c0$1@speranza.aioe.org> (permalink)
References <ipedl3$j3i$1@dont-email.me> <4dbb52d2$0$77724$c30e37c6@exi-reader.telstra.net>

Show all headers | View raw


Geoff,

I wont speak for the reasons he is creating a recordset and then passing it 
to bBrowser but there are perfectly valid reasons for it. The number one 
reason is bBrowser needs a ADOServer, not the recordset. I always create and 
use a recordset, not an ADOServer. In the case that the users hits the ... 
and wants a braower, then I create the ADOServer from the recordset and pass 
it to bbrowser:use.

Regards,
Willie

"Geoff Schaller"  wrote in message 
news:4dbb52d2$0$77724$c30e37c6@exi-reader.telstra.net...

> what im i doing wring here ?

Just about everything <g>.

I don't quite understand why you creating a recordset and then passing
it to the server. Arse about in my books. And why all that looping and
waiting????

Robert has perfectly clear examples - why don't you start with them?
Essentially the process should be:

1. create a connection object
2. Set your default connection parameters
3. Store this connection globally for re-use
4. Open your ADOServer with a select statement and that connection
object
5. Close the connection when you close your app

Use the same connection object for all your RS accesses (when you just
want data) or for all your servers. Use the connection object directly
to execute commands or SPs but they often return recordsets anyhow.

Geoff

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