Delorme 6 Manuel D’Utilisation

Page de 437
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.