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


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

Re: ADO

From "Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Subject Re: ADO
Date 2011-05-01 22:22 +0000
Newsgroups comp.lang.clipper.visual-objects
References <ipft17$7c0$1@speranza.aioe.org>
Message-ID <4dbddd33$0$99952$c30e37c6@exi-reader.telstra.net> (permalink)

Show all headers | View raw


Willie,

Two things:

1.	The guy is having trouble so it is a LOT easier to do it the other 
way around. Establish first that you have a valid connection and then 
establish the recordset. Otherwise you have to debug two things for the 
price of one operation. That is why all of Robert's examples work that 
way.

2.	Although I understand that sequence is possible, why do two 
operations when you can have one? Just use the select statement with the 
ADO server and you can ignore the recordset operation first.

The guy is just learning so let's take the easiest course first and then 
add complexity later.

Geoff



"Willie Moore" <williem@wmconsulting.com> wrote in message 
news:ipft17$7c0$1@speranza.aioe.org:

> 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