DeLorme 6 - Manual (Page 182)

XMap User Guide
174
4. Click the Attributes subtab.
5. If it is not already in Design View mode, click the Design View button .
6. Click the Options button and then click Delete Field.
A confirmation message displays.
OR
Right-click the field you want to delete and then click Delete Field.
A confirmation message displays.
7. Click OK to permanently delete the field from the database.
OR
Click Cancel if you do not want to delete the field from the database.
Function and Operator Descriptions
This Help topic describes features that are available in XMap
GIS Editor and XMap GIS Enterprise.
The following definitions describe some of the terms used in the function descriptions
table below.
Data_type–One of integer, float, string or datetime. String may have an optional
length specification: string(integer). For example, string(40).
Date_expression–An expression yielding a datetime result.
Datepart–A special specifier used in date functions. Jump to the bottom of this topic
for a list of datepart specifiers.
Expression–The result of combining several functions or operators.
Field–The name of a field in the table, enclosed in brackets. For example:
[Population2000]. A field has an associated data type in the table.
Logical_expression–An expression yielding either TRUE or FALSE.
Float_expression–An expression yielding a float result.
Integer_expression–An expression yielding an integer result.
Numeric_expression–An expression yielding a numeric result, either integer or
float.
String_expression–An expression yielding a string result.
Function Basic Function Syntax Description
AND logical_expression AND
logical_expression
Returns TRUE if both of two logical
expressions are TRUE, and FALSE
otherwise. The result type is
logical_expression.
AVG AVG( field ) Returns the average of a field's
values. The result type is the same
as the data type of field.
CAST CAST( expression AS
data_type )
Transforms an expression of one
data type into another data type.
The result type is as specified by
data_type.