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


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

Re: Vo2Ado & Report Pro

Path csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.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 Mon, 13 Jun 2011 17:34:18 +0200
Lines 68
Message-ID <95movpFbmuU1@mid.individual.net> (permalink)
References <651ec04c-5b62-4668-b010-d4c6cb2bea34@n11g2000yqf.googlegroups.com> <it51tl$j1d$1@speranza.aioe.org> <313c38cc-c3b1-47d1-ac1a-d32d59f3eae5@b1g2000yql.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 iYL0AGIMKOi4GiY90lfAmQINUEVgFS7e6hLD5mYp8OKDvbjP6M
Cancel-Lock sha1:JDdPM2kXUoPboi/Pa9gVy4Nds8k=
In-Reply-To <313c38cc-c3b1-47d1-ac1a-d32d59f3eae5@b1g2000yql.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:1377

Show key headers only | View raw


Rob,

> I'am building up some VO knowledge again but it is clear that I have
> not worked with VO for a long time....

Programming VO is like riding a bike.
You'll get up speed quickly.

Here is some code that uses RecordSet:GetString()

METHOD EXPORT2file( wExportType ) CLASS Explorer_Verhuur
LOCAL cFile AS STRING
LOCAL ors AS AdoRecordSet
LOCAL cResult AS STRING
LOCAL otb AS TextBox
cFile := GetFileName( wExportType )
cResult := ''
IF !Empty( cFile )
    ors := AdoRecordset{}
    ors:Open( SELF:cPreviousQuery, AdoGetConnection(), adOpenStatic, 
adLockReadOnly, adCmdText )

    IF wExportType = EXPORT_AS_CSV
        cResult := ors:GetString( adClipString, NIL,";",CRLF, "")
    ELSEIF wExportType= EXPORT_AS_TXT
        cResult += ors:GetString( adClipString, NIL,NIL,CRLF, "")
    ELSEIF wExportType=EXPORT_AS_XML
        ors:Save( cFile, adPersistXML )
    ENDIF
    IF !Empty( cResult )
        IF MemoWrit( cFile, cResult )
            otb:=TextBox{,"File successfully created", cFile}
            otb:type:= BUTTONOKAY
            otb:Show()
        ENDIF
    ENDIF

ENDIF
RETURN  NIL

hth

Erik



"Rob van Erk"  schreef in bericht 
news:313c38cc-c3b1-47d1-ac1a-d32d59f3eae5@b1g2000yql.googlegroups.com...

Hello Willie,

Would be great if you can forward me some example file. Today I'am
building up some VO knowledge again but it is clear that I have not
worked with VO for a long time.... I'am able now to connect to my MS
SQL database, edit/delete/add records but still some difficulties to
get the AdoRecordSet:Getstring() functionality working. Think I have
to setup some loop to get all the records out of the database. If you
can help met with some code for ReportPro than this will be a great
step forward for me.

I think you can retrieve my email account but I will send you a
separate message within short.

Thanks for your support !

Brgds,
Rob 

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