js editor
Web development
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 | |