Category : Paradox DBMS
Archive : TECH91.ZIP
Filename : TI132.ASC
Output of file : TI132.ASC contained in archive : TECH91.ZIP
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
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.
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
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/