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