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