Table Field Naming Conventions
When naming fields in tables, use the following format.
TableAlias.PrefixFieldName
Parameters
- TableAlias
Specifies the name or alias for a table.
Prefix
Indicates the data type for a table field. The following table lists the suggested prefixes for Prefix.Prefix Description c
Character
y
Currency
d
Date
t
DateTime
b
Double
f
Float
g
General
i
Integer
l
Logical
m
Memo
n
Numeric
q
Varbinary
v
Varchar, Varchar (Binary)
w
Blob
- FieldName
Specifies the name of the field.
Example
The following example illustrates how the letter "c" indicates that the LastName field of the Customer table has Character type:
Customer.cLastName
See Also
Reference
Constant Naming Conventions
Object Naming Conventions
Variable Naming Conventions
Window Naming Conventions