home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware 1 2 the Maxx
/
sw_1.zip
/
sw_1
/
TEXT
/
PDX_ALL.ZIP
/
TI132.ASC
< prev
next >
Wrap
Text File
|
1991-11-05
|
5KB
|
199 lines
PRODUCT : Paradox NUMBER : 132
VERSION : All
OS : DOS
DATE : November 5, 1991 PAGE : 1/3
TITLE : Useful Picture Statements
A picture is a powerful and flexible tool for controlling what a
user can type into a field during data entry. You can use
pictures to shape and limit what the user can type into a field
and make data entry easier by filling in required or default
values automatically.
To define a picture for a field, edit the table. Choose Modify |
Edit and enter in the name of the table. Next press <F10> for
the Edit menu, and use the following menu choices: Valcheck |
Define | Picture. At this point, enter in the picture statement
for the field. This document contains a list of useful picture
statements.
Pictures can also be used with the PAL Accept command. See
Chapter 20 of the Pal User's Guide for a discussion of the Accept
command.
Definition of Picture Symbols:
Match characters:
# Accepts ONLY a digit
? Accepts ONLY a letter EITHER upper or lower
@ Accepts ANY character
& Accepts ONLY a letter, converts it to upper case
! Accepts ANY character, converts letters to upper case
Any other character typed that is not defined as a
match character or a special character is taken
literally.
Special characters:
; Take next character literally
* Repetition in picture
[] Optional input
{} Option grouping
, Option separator
PRODUCT : Paradox NUMBER : 132
VERSION : All
OS : DOS
DATE : November 5, 1991 PAGE : 2/3
TITLE : Useful Picture Statements
Useful Picture Statements:
ZIP Code with optional last four digits #####[{-}####]
SSN with automatic fill in of dashes ###-##-####
SSN with fill in of dashes using spacebar or - ###{-}##{-}####
Allow letters only - Spaces NOT allowed *?
Allow letters only and capitalize the first one &*?
Allow letters only - capitalize all letters *&
Capitalize the first letter only !*@
Capitalize the first letter of every word (I) *[![*?][* ]]
Capitalize the first letter of every word (II) !*[ * !,@]
Capitalize the first letter of every word (III)
*{ ,.}!*{{ ,.}*{ ,.}!,@}
Capitalize the first letter of every word (IV)
*[[*#[ ]]![*?][@][ ]]
Capitalize the first letter of every word after a comma, blank
space or parenthesis:
!*[{ ,.,(,;,}*{ ,.,(,;,}!,@]
Simulate a Time data type with format of HH:MM:SS:
{0#,1#,2{0,1,2,3}}:{0,1,2,3,4,5}#:{0,1,2,3,4,5}#
Simulate a Time data type with form of HH:MM and :SS optional:
{0#,1#,2{0,1,2,3}}:{0,1,2,3,4,5}#[:{0,1,2,3,4,5}#]
Simulate a Time data type with form of HH:MM AM or HH:MM PM
{1{:,{0,1,2}:},{2,3,4,5,6,7,8,9}:}{0,1,2,3,4,5}#
{AM,PM}
Phone number w/ automatic fill in of dashes ###-####
Phone number w/ automatic dashes area code opt. [(###)]###-####
Phone number w/1-800 optional [{1-800-,(###)}]###-####
Date - automatic fill in of slashes {##/##/##,#/##/##,}
Date - forces 01 for day w/auto fill in of
slashes{##/01/##,#/01/##}
PRODUCT : Paradox NUMBER : 132
VERSION : All
OS : DOS
DATE : November 5, 1991 PAGE : 3/3
TITLE : Useful Picture Statements
Date - forces 01 for day w/system clock year {##/01/[##],#/01/[##]}
Automatic entering from a list based on partial
keystrokes of word. {Paradox,Quattro,dBASE}
Allows entry of Miss, Ms., Mr., or Mrs. M{iss,s.,r{.,s.}}
Allows additional entry of Reverend, Doctor,
Father and Pastor:
{Doctor,Father,M{iss,r{s.,.[
;&Mrs.]},s{.,gr.}},Pastor,Reverend}
If you want an 8 digit number with commas in the correct places
(i.e. 10,666,123) use the picture:
*8[#]
and use Image/Format/Commas to place the commas in the number.
If you do not want any decimal places to show in the number, be
sure to type in a '0' at the "Number of decimal places:" prompt.