How do I convert all records back to lowerl case? 
Author Message
 How do I convert all records back to lowerl case?

I converted all my names to upper case and now have changed my mind.  How do I
conver them back?

*** BALLROOM ***** SWING ***** LATIN ***** COUNTRY/WESTERN ***
Clay's Dance Studio                             http://www.***.com/ ~claybird

Portland, OR 97223                                   (503) 292-0371
****** (Bring pleasure and new friends into your life thru dance!) ******



Sun, 28 Dec 1997 03:00:00 GMT
 How do I convert all records back to lowerl case?

Quote:
>I converted all my names to upper case and now have changed my mind.  How do

I >conver them back?

here is something pretty close .. Initial caps

method makeInitialCaps()
var
        tName                   string
        tc                              TCursor
endvar
tName = ":priv:LABELS"
message("changing from CAPS to Initial Caps")
if tc.open(tName) then
        tc.edit()
        scan tc:
                ; convert to initialcaps after converting to lowercase
                tc."Field 1" = format("cc", lower(tc."Field 1"))
                tc."Field 2" = format("cc", lower(tc."Field 2"))
                tc."Field 3" = format("cc", lower(tc."Field 3"))
                tc."Field 4" = format("cc", lower(tc."Field 4"))
                tc."Field 5" = format("cc", lower(tc."Field 5"))
                tc."Field 6" = format("cc", lower(tc."Field 6"))
                tc."Field 7" = format("cc", lower(tc."Field 7"))
        endScan
        tc.endEdit()
        tc.close()
else
        MsgStop("ERROR","Error opening table " + tName )
endif
endmethod

I convert initial caps on table LABELS, which has 7 fields
I got this code from one of the borland TIxxxx

hope it helps
 cpm



Sun, 28 Dec 1997 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Converting record case in PDOX 5.0

2. CLIPPER to TC float, convert, use, convert back?

3. Convert Mixed case data to Upper/Lower case

4. Convert Mixed Case to Upper Case for Report

5. Roll back doing for ever

6. Rolling back input done via insert into and replace cmds

7. preserving case when doing selects/compares in stored procedure

8. Problem : Doing case-insensitive queries...

9. Doing case-insensitive searches

10. Can you convert relational record to flat record

11. Converting from ADO Record Sets to a ADO.NET record set object

12. Converting IP addresses from decimal to dotted decimal notation and back


 
Powered by phpBB® Forum Software