home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware 1 2 the Maxx
/
sw_1.zip
/
sw_1
/
TEXT
/
PDX_ALL.ZIP
/
TI520.ASC
< prev
next >
Wrap
Text File
|
1991-09-11
|
1KB
|
67 lines
PRODUCT : PARADOX NUMBER : 520
VERSION : ALL
OS : DOS
DATE : September 11, 1991 PAGE : 1/1
TITLE : Rounding values in a field
To enter a script that will round the values in a specific field,
select [F10] Scripts\Editor\Create and type ROUND and press
[ENTER]. On the screen, type the following code:
Edit "Table_Name"
Moveto [Field_Name]
Scan
[]=Round([],n)
Endscan
Then select [F10] and Do_it!
To play the script, select [F10] Scripts\Play, type ROUND and
press [ENTER].
Comments:________________________________________________________
Edit "Table_name" Selects the table. Replace the word
Table_Name with the actual name of your
table, don't forget to type the quotation
marks.
Moveto [Field_name] Selects the field. Replace the word
Field_Name with the name of the filed to
be changed, don't forget to type the
square brackets.
Scan Tell Paradox to scan through record by
record.
[]=Round([],n) Does the actual rounding. Replace n with
the number of decimal places desired.
Endscan Ends the scan.