home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Monster Media 1993 #2
/
Image.iso
/
database
/
p4w_all.zip
/
TI1368.ASC
< prev
next >
Wrap
Text File
|
1993-03-31
|
5KB
|
199 lines
PRODUCT : Paradox for Windows NUMBER : 1368
VERSION : 1.0
OS : WIN
DATE : March 31, 1993 PAGE : 1/3
TITLE : Useful Picture Statements
Intended Audience
All Paradox for Windows users.
Prerequisites
Chapter 9, User's Guide
Purpose
This document will illustrate some 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, choose File | Utilities |
Restructure, then choose the table you want (you can also define
a picture when you are creating a table). From the Field Roster,
select the field that you want to set a picture on. To specify a
picture for the field, either type the picture pattern that you
want in the Picture text box, or choose Assist. When you are
finished specifying the picture for the field(s), save the table
by choosing the Save button. For more information on Assist,
refer to Chapter 9 in the User's Guide.
Below is a description of the picture symbols and a listing of
useful picture statements.
Definition of Picture Symbols:
Match characters:
# Accepts ONLY a numeric 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.
PRODUCT : Paradox for Windows NUMBER : 1368
VERSION : 1.0
OS : WIN
DATE : March 31, 1993 PAGE : 2/3
TITLE : Useful Picture Statements
Special characters:
; The next character is literal, not a picture-string
character
* The next character can be repeated any number of times.
Or, specify how many occurrences of the next letter to
require.
[] Characters inside brackets are optional
{} Characters inside braces are grouped
, Alternative values
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, spaces not
allowed:
&*?
Allow letters only - capitalize all letters *&
Capitalize the first letter only of the first word
!*@
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}#
PRODUCT : Paradox for Windows NUMBER : 1368
VERSION : 1.0
OS : WIN
DATE : March 31, 1993 PAGE : 3/3
TITLE : Useful Picture Statements
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 optional
[(###)]###-####
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/##}
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 Dr., Doctor, Father, Miss, Mrs., Mr.,
Mr. & Mrs., Ms., Msgr., Pastor, and Reverend:
{D{r.,octor},Father,M{iss,r{s.,.[ ;& Mrs.]},s{.,gr.}},Pastor,Reverend}
Suggested Reading:
Chapter 9, User's Guide
DISCLAIMER: You have the right to use this technical information
subject to the terms of the No-Nonsense License Statement that
you received with the Borland product to which this information
pertains.