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


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

Re: Vo2Ado & Report Pro

From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Vo2Ado & Report Pro
Date 2011-06-13 10:56 -0500
Organization Aioe.org NNTP Server
Message-ID <it5bvq$epb$1@speranza.aioe.org> (permalink)
References <651ec04c-5b62-4668-b010-d4c6cb2bea34@n11g2000yqf.googlegroups.com> <it51tl$j1d$1@speranza.aioe.org> <313c38cc-c3b1-47d1-ac1a-d32d59f3eae5@b1g2000yql.googlegroups.com> <95movpFbmuU1@mid.individual.net>

Show all headers | View raw


Erik,

Thanks for the sample.

Regards,
Willie

"E®!k \/!$$E®"  wrote in message news:95movpFbmuU1@mid.individual.net...

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