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


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

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 Fri, 29 Apr 2011 21:43:52 -0500
Organization Aioe.org NNTP Server
Lines 40
Message-ID <ipft17$7c0$1@speranza.aioe.org> (permalink)
References <ipedl3$j3i$1@dont-email.me> <4dbb52d2$0$77724$c30e37c6@exi-reader.telstra.net>
NNTP-Posting-Host 028Mn+e0uF4OgoiFTh0Hrw.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:998

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