home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
World_Of_Computer_Software-02-385-Vol-1of3.iso
/
t
/
tech91.zip
/
TI619.ASC
< prev
next >
Wrap
Text File
|
1991-08-26
|
3KB
|
133 lines
PRODUCT : Paradox NUMBER : 619
VERSION : 3.5
OS : PC DOS
DATE : August 26, 1991 PAGE : 1/2
TITLE : Creating and using PAL variables in reports and forms
Using PAL variables in reports and forms is a new feature added
to Paradox 3.5. Variables can be placed in a report or form
while in the report or form design mode. The steps are as
follows:
From the Paradox 3.5 main menu, choose {Report} {Change}
or {Form} {Change}.
Select the appropriate table and report or form number.
Press <F10> and select {Field} {Place} {Calculated}.
You may now type in a memory variable or a calculation
which uses variables (eg. VAR where "VAR" is the name of
the memory variable or VAR * VAR1 where "VAR" and "VAR1"
are numeric variables involved in a calculation) and
press <Enter>, then press <F2> to save the file.
NOTE: Before printing the report or viewing the form, the memory
variables used will need to be assigned values:
One way to assign a value to a variable is through a Miniscript.
For example, here are the steps that are necessary to set a
variable called "VAR" to the number 400
Press <ALT><F10> to bring up the PAL menu.
Choose {Miniscript} from the PAL menu.
Now type VAR = 400. The expression will set the memory
variable called "VAR" to the numeric value 400.
NOTE: Variable can also be set to calculations, text values, and
dates as in the following expressions:
VAR1 = (100+VAR)/1000
VAR2 = "This is a text string"
VAR3 = 12/15/91
PRODUCT : Paradox NUMBER : 619
VERSION : 3.5
OS : PC DOS
DATE : August 26, 1991 PAGE : 2/2
TITLE : Creating and using PAL variables in reports and forms
A variable can also be set to a value on a table. For example,
if a query with a CALC SUM is run, an Answer table is generated
with a one field record. To set the variable to that field in
the Answer table, move the cursor to the field and do a
Miniscript with the expression VAR = []. Before doing so, make
sure the cursor is in the correct field since [] refers to the
current field.