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


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

Re: ADO

From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: ADO
Date 2011-05-01 21:47 -0500
Organization Aioe.org NNTP Server
Message-ID <ipl5vu$f76$1@speranza.aioe.org> (permalink)
References <ipft17$7c0$1@speranza.aioe.org> <4dbddd33$0$99952$c30e37c6@exi-reader.telstra.net>

Show all headers | View raw


Geoff,

I use ADO recordsets for the same reasons you tell folks not to use data 
windows. I don’t want the extra overhead. For the rair occasions that I need 
to create a browser, I take the recordset (if it is already open) and create 
the ADOServer from it. If I haven't already created the ADORecordset, then I 
skip that step and create the ADOServer directly with the SQL statement.

I do agree though that when learning, it is good to go as simple as possible 
first. You can always add complexity later.

Regards,
Willie

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

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