Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!newsfeed.kamp.net!newsfeed.kamp.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: =?iso-8859-1?Q?E=AE!k_\\/!$$E=AE?= Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Vo2Ado & Report Pro Date: Mon, 13 Jun 2011 21:57:26 +0200 Lines: 32 Message-ID: <95n8d4F5eoU1@mid.individual.net> References: <651ec04c-5b62-4668-b010-d4c6cb2bea34@n11g2000yqf.googlegroups.com> <313c38cc-c3b1-47d1-ac1a-d32d59f3eae5@b1g2000yql.googlegroups.com> <95movpFbmuU1@mid.individual.net> <9f79fe77-3e07-470d-ad8f-50d10f73056e@n11g2000yqf.googlegroups.com> <174987e1-4fcf-40d6-a1c6-c8fec5c2dabc@r20g2000yqd.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Trace: individual.net XkR9RwFqkUY9zHQXtbU9Sw6gK/pjvTyZvPVSpHmCDxiHjcFLez Cancel-Lock: sha1:8yTvb6A+H4rCSghUl0Wye2y6DLk= In-Reply-To: <174987e1-4fcf-40d6-a1c6-c8fec5c2dabc@r20g2000yqd.googlegroups.com> X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-Newsreader: Microsoft Windows Live Mail 15.4.3508.1109 X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3508.1109 Xref: x330-a1.tempe.blueboxinc.net comp.lang.clipper.visual-objects:1383 Did not try, but AdoServer:Recordset should do the job. Note that if you change the column order in bBrowser, this will not be seen in the Recordset. Erik Erik "Rob van Erk" schreef in bericht news:174987e1-4fcf-40d6-a1c6-c8fec5c2dabc@r20g2000yqd.googlegroups.com... Erik, One question about your code. I created a Datawindow and added a bBrowser using an ADO Server. All works fine. But, using a "Export to CSV" button I would like to export the currently shown data of the datawindow using your EXPORT2file method. However, in the method a new AdoRecordSet is defined and it is using SELF:cPreviousQuery as first parameter to open the database. How can I just use the EXPORT2File method to export the data that is shown in bBrowser without a need to include a new query statement as first parameter in the method? So, basically I like to use a kind of "use current open AdoRecordset" to simply export the data to CSV without running a SQL statement in the EXPORT2File method. Hope you can help me. Thks, Rob