home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware 1 2 the Maxx
/
sw_1.zip
/
sw_1
/
TEXT
/
PDX_ALL.ZIP
/
TI540.ASC
< prev
next >
Wrap
Text File
|
1992-02-05
|
2KB
|
67 lines
PRODUCT : Paradox NUMBER : 540
VERSION : All
OS : DOS
DATE : February 5, 1992 PAGE : 1/1
TITLE : Converting a Field in a Table Using Format
The following script demonstrates the use of SCAN to change
Fieldname to upper case. A complete description of SCAN can be
found in the PAL User's Guide. Refer to the PAL User's Guide's
index under "Scan command" for the page number.
This is handled through the use of FORMAT, which is explained in
detail the PAL User's Guide. Refer to the PAL User's Guide's
index under "Format function" for the page number.
Note:
TBLNAME is the name of the table.
Fieldname is the name of the field.
The following script converts the field Fieldname, in the table
TBLNAME, to upper case, via the use of the FORMAT specification
cu.
EDIT "TBLNAME" ;Place the table in edit mode.
SCAN
[Fieldname] = format("cu",[Fieldname])
ENDSCAN ;Scan and convert field values.
DO_IT! ;Save all changes.
The following script converts the field Fieldname, in Table
TBLNAME, to lower case, via the use of the FORMAT specification
cl.
EDIT "TBLNAME" ;Place the table in edit mode.
SCAN
[Fieldname] = format("cl",[Fieldname])
ENDSCAN ;Scan and convert field values.
DO_IT! ;Save all changes.
The following script converts the field Fieldname, in Table
TBLNAME, to initial capital letter only, via the use of the
FORMAT specification cc.
EDIT "TBLNAME" ;Place the table in edit mode.
SCAN
[Fieldname] = format("cc",lower([Fieldname]))
ENDSCAN ;Scan and convert field values.
DO_IT! ;Save all changes.