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