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