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