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


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

Re: Vo2Ado & Report Pro

Path csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!newsfeed.kamp.net!newsfeed.kamp.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From E®!k \\/!$$E® <nospam@nospam.url>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Vo2Ado & Report Pro
Date Sun, 12 Jun 2011 20:04:10 +0200
Lines 38
Message-ID <95kdcoFddlU1@mid.individual.net> (permalink)
References <651ec04c-5b62-4668-b010-d4c6cb2bea34@n11g2000yqf.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 FxRWZUz0gEVr54l4VBAadgaNJVbCF8ky89BTVQs6BqJraz+4q7
Cancel-Lock sha1:Of9Y74HeaqlhXUUTopbpjU3NWh8=
In-Reply-To <651ec04c-5b62-4668-b010-d4c6cb2bea34@n11g2000yqf.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:1362

Show key headers only | View raw


Hi Rob,

1) there are several ways to do this.
a) use automation, open a Excel worksheet and pass and array with your data 
to a Excel range.
b) use the AdoRecordSet:Getstring() method to create a CSV file.

2) have you studied the VO2ADO  report pro samples?

regards,

Erik



"Rob van Erk"  schreef in bericht 
news:651ec04c-5b62-4668-b010-d4c6cb2bea34@n11g2000yqf.googlegroups.com...

Hello all,

Two questions:

1) Are there any examples available on how to export SQL Data (VO2.8
using Vo2Ado) to another format like Excel? I have some examples
showing SQL data in bBrowser cells but no idea how I can export data
to Excel format.

2) I am using Report Pro 3.9 but do not understand how I can open a
SQL database in Report Pro. In this forum I read something about using
RDD but not sure what is exactly meant. By default I think I need to
use some ODBC connection method in Report Pro but preferably I use Ado
directly from within ReportPro (if possible).

It has been a long time since I have been working with VO so any help
to support me to start up using VO again would be helpful.

Thks, 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Vo2Ado & Report Pro Rob van Erk <erk.v@hotmail.com> - 2011-06-12 10:03 -0700
  Re: Vo2Ado & Report Pro E®!k \\/!$$E® <nospam@nospam.url> - 2011-06-12 20:04 +0200
  Re: Vo2Ado & Report Pro "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-06-12 23:43 +0000
    Re: Vo2Ado & Report Pro Rob van Erk <erk.v@hotmail.com> - 2011-06-13 00:08 -0700
  Re: Vo2Ado & Report Pro "Willie Moore" <williem@wmconsulting.com> - 2011-06-13 08:04 -0500
    Re: Vo2Ado & Report Pro Rob van Erk <erk.v@hotmail.com> - 2011-06-13 07:25 -0700
      Re: Vo2Ado & Report Pro E®!k \\/!$$E® <nospam@nospam.url> - 2011-06-13 17:34 +0200
        Re: Vo2Ado & Report Pro "Willie Moore" <williem@wmconsulting.com> - 2011-06-13 10:56 -0500
          Re: Vo2Ado & Report Pro Rob van Erk <erk.v@hotmail.com> - 2011-06-13 10:13 -0700
            Re: Vo2Ado & Report Pro Rob van Erk <erk.v@hotmail.com> - 2011-06-13 12:28 -0700
              Re: Vo2Ado & Report Pro E®!k \\/!$$E® <nospam@nospam.url> - 2011-06-13 21:57 +0200
                Re: Vo2Ado & Report Pro E®!k \\/!$$E® <nospam@nospam.url> - 2011-06-13 21:59 +0200
                Re: Vo2Ado & Report Pro Rob van Erk <erk.v@hotmail.com> - 2011-06-14 09:52 -0700

csiph-web