Category : Paradox DBMS
Archive   : TECH91.ZIP
Filename : TI619.ASC

 
Output of file : TI619.ASC contained in archive : TECH91.ZIP







PRODUCT : Paradox NUMBER : 619
VERSION : 3.5
OS : PC DOS
DATE : September 11, 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 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 , then press 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 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 : September 11, 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.












































  3 Responses to “Category : Paradox DBMS
Archive   : TECH91.ZIP
Filename : TI619.ASC
”

  1. Daniel says:
    January 27, 2013 at 3:59 pm

    Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. Joshie says:
    March 18, 2014 at 4:57 pm

    This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. DiskingRound says:
    January 14, 2015 at 10:57 pm

    But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/