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:

	Copy Code
Customer.cLastName

See Also