home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Monster Media 1993 #2
/
Image.iso
/
database
/
pcf70b.zip
/
PCF1.321
/
CARD
next >
Wrap
Text File
|
1993-06-14
|
14KB
|
322 lines
PC-FILE 7 QUICK REFERENCE CARD
* NAVIGATION KEYS
Navigation keys allow you to move around the screen.
ENTER Activates the current entry; move to the next step
ESC Cancels the current operation; move back one step; abandon
changes made to current record.
ALT Toggles (switches) between the work area and the menu bar.
If you hold down ALT and press the first letter of a menu
bar option, the pull-down menu displays.
HOME Moves the cursor to the leftmost position or choice.
END Moves the cursor to the rightmost position or choice.
CTRL-RT ARROW Move the cursor to first character of the next word.
CTRL-LFT ARROW Move cursor to first character of the previous word.
CTRL-HOME Moves the cursor to the top-leftmost position in a memo
field or edit window
CTRL-END Moves the cursor to the bottom-rightmost position in a
memo field or edit window
PGUP Scrolls the currently visible window area up one screen.
PGDN Scrolls the currently visible window area down one screen.
CTRL-PGUP When viewing records, moves to the first field.
CTRL-PGDN When viewing records, moves to the last field
TAB Moves the cursor to the next field, button, or option.
SHIFT-TAB Moves the cursor the opposite direction of TAB.
CTRL-TAB Move to the right in a Table view, modify mode.
CTRL-SHIFT-TAB Move to the left in a Table view, Modify mode.
LFT ARROW Moves the cursor one position to the left.
RT ARROW Moves the cursor the opposite direction of LFT ARROW.
UP ARROW Moves cursor up one position, field, or option.
DN ARROW Moves the cursor the opposite direction of UP ARROW.
* EDITING KEYS
Editing keys allow you to modify text.
BACKSPACE Moves the cursor one position to the left, deleting the
character in that position.
DEL Deletes the character at the cursor or selected text.
CTRL-DEL Deletes the word the cursor is currently on.
INS Toggles between insert and replace mode.
SHIFT-RT ARROW Start or extend the selection one position right.
SHIFT-LT ARROW Start or extend the selection one position left.
SHIFT-UP ARROW Starts or extends the selection up one line.
SHIFT-DN ARROW Starts or extends the selection down on line.
SHIFT-END Selects all characters to the end of the line.
SHIFT-HOME Selects all characters to the beginning of the line
CTRL-SHIFT-RT ARROW Starts or extends the selection one word right.
CTRL-SHIFT-LFT ARROW Starts or extends the selection one word left.
SHIFT-DEL Delete selected text and copy to buffer.
CTRL-INS Copy selected text to buffer.
SHIFT-INS Paste text from buffer.
* HOT KEYS
CTRL-A Continue most recent search
CTRL-B Blank from cursor to end of field
CTRL-C Display the calculator (Tools, Calculator)
CTRL-D Drop to DOS (Tools, Drop to Dos)
CTRL-E Expand memo field to a window
CTRL-F Duplicate field from previously-viewed record
CTRL-H Forces Insert mode ON
CTRL-I Switch to another index (File, Index Switch)
CTRL-J Dial phone number - "jingle" (Tools, Telephone Dialer)
CTRL-L Print snapshot label
CTRL-M Display macro menu to invoke macro (Macros, Execute)
CTRL-N Display next record
CTRL-O Toggle between flip data & insert tilde
CTRL-P Display previous record
CTRL-Q Begin spell checking
CTRL-R Duplicate previously-viewed or added record
CTRL-S Simple Search (Search, Simple)
CTRL-T Toggle between current and most recent view
CTRL-V View memo field contents
CTRL-W Display cursor location (Letters & Reports)
CTRL-Y Begin and end recording macro
ALT-O Chooses OK in dialog boxes and windows
ALT-C Chooses Cancel in dialog boxes and windows
ALT-F1 Brings up the general help screen
ALT-F7 Use with arrow keys to move boxes and windows
ALT-F8 Use with arrow keys to resize memo window
ALT-F10 Maximize memo window
SHIFT-DEL Delete selected text and copy to buffer.
CTRL-INS Copy selected text to buffer.
SHIFT-INS Paste text from buffer.
TYPES OF SIMPLE SEARCHES
xxx generic (exact match based on position in field)
~xxx scan across
?xxx sounds-like
___x wildcard (cannot be used in numeric fields)
>xxx comparison operator (can use >,<,>=,<=, and !)
(Where "xxx" is an appropriate string or value)
WHEN CALCULATIONS ARE ASKED FOR:
arithmetic operators:
+ addition
- subtraction or negation
* multiplication
/ division
% modulo (remainder)
^ exponentiation
logical operators:
& and
| or
comparison operators:
= equal
!= not equal
> greater than
>= greater than or equal
< less than
<= less than or equal
string operators:
UPCASE(argument) converts "argument" to uppercase
LOWCASE(argument) converts "argument" to lowercase
MIXCASE(argument) converts "argument" to leading uppercase,
following lowercase
LASTWORD(argument) isolates last word in "argument"
FIRSTWORD(argument) isolates first word in "argument"
TRIM(argument) trims all trailing spaces from "argument"
argument;argument (semicolon) concatenates (joins) strings
"Argument" can be a field name, a string of characters surrounded by
quotes ("xxx"), or a nested string calculation.
special calculations:
(@RANDOM#) creates a random number between 0 and 1
(@TODAY#) creates todays relative "day number"
(@DAY#,mask) get date from stack, convert to day#
mask tells date format:
ymd ydm mdy myd dmy dym yymmdd
(@DATE,mask) get day# from stack, convert to date
mask tells date format: examples mdy/ dmy-
(@key1,dbase2,key2,answer2)
a relational lookup
(@*,answer3) a subsequent relational lookup into same record
(@TIMENOW) get the current 24-hour clock time
example arithmetic calculation:
((cost + adjust) / 100)
example comparison calculation:
((age >= 21 & age < 40) & sex = "F")
example string calculation: trim firstname and concatenate lastname
(TRIM(firstname);" ";lastname)
example date arithmetic: difference between 2 dates
(date2(@DAY#,mdy) - date1(@DAY#,mdy))
example date arithmetic: date 60 days later
((date1(@DAY#,mdy) + 60)(@DATE,mdy/))
COMMANDS WITHIN MACROS
Key Macro definition Key combinations
ENTER {ENTER} With ALT {ALT-F}
ESC {ESC} With CTRL {CTRL-D}
BACKSPACE {BKSP} With SHIFT {SHIFT-TAB}
DELETE {DEL}
INSERT(toggle) {INS} All other keys are entered as
INSERT(force) {INSERT_ON} typed from the keyboard without
DOWN ARROW {DOWN} surrounding braces {}.
UP ARROW {UP}
RIGHT ARROW {RIGHT}
LEFT ARROW {LEFT}
HOME {HOME}
END {END}
Function key {Fn} (n = function key number)
PAGE UP {PGUP}
PAGE DOWN {PGDN}
TAB {TAB}
{DELAY-nn} (nn = tenths of a second)
{INPUT} pauses for user input
REPORT COMMAND LANGUAGE
The sections of the report
:COVER once at beginning of report
:HEADING top of each page
:DETAIL once for each record printed
:SUBTOTAL at each subtotal break
:FOOTING bottom of each page
:TOTAL at end of the report
Commands in filename.rep (1 command per line):
[xxx] field xxx data prints here
[COUNT*] print count of records printed so far
[DATE*] today's date prints here
[KEYIN*prompt] ask operator input, print here
[PAGE*] print page number here
[RECORDS*] print no. of records in database
[SELECT*] print the selection criteria
[SORT*] print the primary sort field name
[SUBCMD*n] print subtotal trigger formula (n = sublevel)
[SUBCOUNT*n] print count of records in subtotal group (n= sublevel)
[SUBFLD*n] print field name of subtotal break field (n = sublevel)
[SUBID*n] print data from subtotal break field (n = sublevel)
[SUBLEVEL*] print level number of subtotal break
[TIME*] the current time prints here
A nn,nnn,nn print ASCII printer control codes here
<xxx> field xxx data (excess spaces removed)
"xxx" a constant
=nn tab to column nn
/n insert n newlines
.FF form feed to new page
.CP nn conditional skip to new page
.IF (condition) if condition is true, include following commands
.ELSE if condition is not true, include following
.ENDIF end of IF construct
.GROUP start a group (no blank lines)
.EGROUP end a group
.EGROUP R end a group, replace blank lines
.REFORMAT nn begin reformat, "nn" is width to reformat
.ENDREFORMAT end reformat
.BOLD turn BOLD printing on
.CONDENSED turn CONDENSED printing on
.NORMAL turn NORMAL printing on
.UNDERLINE turn UNDERLINE printing on
.ITALIC turn ITALIC printing on
.DOUBLEWIDE turn DOUBLEWIDE printing on
(a+b):z,zz#.##: a calculated answer, with output mask
(@K1,DB,k2,x2):@@@: a relational lookup
(@*,fld):@@@@: a relational lookup into the same record
Report Print Masks (examples)
:@@@@@@@@@@@@: a character field mask
:#####: numbers, all digits appear
:zz,zz#.##: zero suppress, with commas
:$$$$$$.##: floating dollar sign
:******.##: asterisk check protection
:Wnn: word wrap mask (nn = number of characters wide)
:: null mask (nothing prints)
MAIL-MERGE COMMANDS (IMBED IN LETTER)
.<fieldname> insert data, blanks stripped
.[fieldname] insert data, no blanks removed
.<KEYIN*prompt> insert data from keyboard
.<DATE*> insert today's date
.GROUP start a group (no blank lines)
.EGROUP end a group
.EGROUP R end a group, replace blank lines
.FORMFEED skip to new page on printer
.FF skip to new page on printer
.CP nn conditional skip to new page
.REFORMAT nn begin reformat, "nn" is width to reformat to
.ENDREFORMAT end reformat
.IF (condition) if condition is true, include following
.ELSE if condition not true, include following (optional)
.ENDIF end of IF/ELSE construct
.<(a+b):z,zz#.##:> a calculated answer
.<(@K1,DB2,k2,x2):@@@@@@:> a relational lookup answer
COMMANDS IN PROFILE FILES OR ON COMMAND LINE
/ADDPW,xxx password allowing additions to database
/BOLD,n define printer codes for boldface type
/CASEFIND searches will be case sensitive
/CASESORT sorts will be case sensitive
/CHARMODE set character display mode
/COLOR,n set color pallet
/CONDENSED,n define printer codes for condensed type
/DATEFORMAT,x define default data format
/DELPW,xxx password allowing deletions in database
/DOUBLEWIDE,n define print codes for double wide type
/DRIVE,x define default disk drive for database
/FILE,x define default database
/ITALIC,n define print codes for italic type
/LANDSCAPE,n define printer codes for landscape page orientation
/MEMOW,n the width of the Memo window
/MODPW,xxx password allowing modify in database
/NORMAL,n,n ASCII values to cause normal print size
/NOEMS prevents use of expanded memory
/NOXMS prevents use of extended memory
/NOSNOW prevents snow or flickering on some CGA monitors
/PAGELEN,n size of page (no. of print lines)
/PATH,x define default path for database
/PHINIT,xxxx modem initialization string
/PHLONG,n define long distance code
/PHPORT,COMx the COM port to Jingle phone calls thru
/PHPRE,xxx telephone "connect" command characters
/POSTSCRIPT defines for PostScript output
/PRINTPW,x define password for access to Print menu
/PROPORTIONAL, n define printer codes for proportional type
/PRPORT,LPTx printer output port
/READONLY open database in read-only mode (must be in database.PRO)
/SNAP1,n define first snapshot label report
/SNAP2,n define second snapshot label report
/SNAP3,n define third snapshot label report
/SNAP4,n define fourth snapshot label report
/SNAP5,n define fifth snapshot label report
/SYSPW,xxx password allows system operations
/UNDERLINE,n define print codes for underlined type
/USEPW,xxx password allows use of the database
/USER1,n user-defined printer code 1
/USER2,n user-defined printer code 2
/USER3,n user-defined printer code 3
/USER4,n user-defined printer code 4
/USER5,n user-defined printer code 5
COMMANDS FOR FORMULA INDEXES
ABS(num) DAY(date) ISDIGIT(char)
ASC(char) DESCEND(char) ISLOWER(char)
AT(str,str) DOW(date) ISUPPER(char)
CALC("(pcfilecalc)") DTOC(date) LEFT(char,len)
CDOW(date) EXP(num) LEN(char)
CHR(num) IIF(cond,expr,expr) LOWER(char)
CMONTH(date) INT(num) LTRIM(char)
CTOD(char) ISALPHA(char) MAX(num,num)
DATE() RIGHT(char,num) STUFF(char,num,num,char)
MIN(num,num) ROMAN(char) SUBSTR(char,num,num)
MOD(num,num) ROUND(num,num) TIME()
MONTH(date) RTRIM(char) TRIM(char)
RECCOUNT() SOUNDEX(char) TYPE(any)
RECNO() SPACE(num) UPPER(char)
RECSIZE() STR(num,num,num) VAL(char)
REPLICATE(char,num) TOSTR(any) YEAR(date)