Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #5835
| From | Karl Wochele <kw@e﹐s-system.dot.de> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Records not updated using Upper() |
| Date | 2013-09-17 15:53 +0200 |
| Message-ID | <b9r563FduniU1@mid.individual.net> (permalink) |
| References | <b56d351a-0c60-4d6b-ab57-7dbce206000f@googlegroups.com> |
Hi Rob,
you should insert oServer:Setorder(0) before oServer:gotop()
If you change the KeyValue of the current record your next skip might
take you anywhere, even to eof() ...
HTH
Karl
Am 17.09.2013 15:42, schrieb Rob van Erk:
> I have a DBF with upper and lower case data in field COMPNAME. I need to uppercase all data in that field. The DBF's allows duplicate records and the index is on COMPNAME. The following code refuses to change contents of COMPNAME to uppercase for the first record
>
> COMPNAME
> ======== => output:
> artmcxa01 artmcxa01
> artmcxa01 ARTMCXA01
> artmcxa02 artmcxa02
> artmcxa02 ARTMCXA02
> artmcxa03 ARTMCXA03
> artmcxa04 ARTMCXA04
>
> Why is the first record not changed to uppercase?
>
> Code:
>
> local sComp as string
>
> oServer:= DSComputersImport{}
> oServer:Zap()
>
> oServer:Appenddelimited("c:\snow\computers.csv",",")
> oServer:GoTop()
>
> do while !oServer:EoF
> sComp := upper(oServer:FIELDGET(#compname))
> oServer:FIELDPUT(#compname, sComp)
> oServer:Skip(1)
> enddo
> oServer:Close()
>
> Thanks for any advise to solve this issue.
>
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Records not updated using Upper() Rob van Erk <erk.v@hotmail.com> - 2013-09-17 06:42 -0700 Re: Records not updated using Upper() Karl Wochele <kw@e©os-system.dot.de> - 2013-09-17 15:53 +0200 Re: Records not updated using Upper() Rob van Erk <erk.v@hotmail.com> - 2013-09-17 07:14 -0700
csiph-web