Pitney Bowes MapXtreme - Manual (Page 184)

Chapter 8: Working with Data
MapInfo ADO.NET Data Provider
MapXtreme v7.1 191 Developer Guide
Insert
INSERT [INTO] { table_name } [ ( column_list ) ]
{ VALUES ({expression | NULL}[, ...n]) | query_specification
Update
UPDATE { table_name }
SET {{ column_name } = { expression | NULL }} [, ...n]
[WHERE < search_condition > ]
Delete
DELETE [FROM] { table_name } [ WHERE < search_condition > ]
< search_condition > ::=
{ [ NOT ] < predicate > | ( < search_condition > ) }
[ { AND | OR } [ NOT ] { < predicate > |
( < search_condition > ) } [ ,...n ] ]
< predicate > ::=
{
expression [ { = | < > | != | > | >= | < | <= } expression ]
| string_expression [ NOT ] LIKE string_expression [ ESCAPE
'escape_character' ]
| expression [ NOT ] BETWEEN expression AND expression
| expression IS [ NOT ] NULL
}
expression
Is a column name, pseudo column, column alias, constant, function, or any combination of column
names, column aliases, constants, and functions connected by an operator(s). Column names and
pseudo columns may be prefixed with a table name or a table alias followed by the dot (“.”)
character.
group_by_expression
Is a reference to a column in the select list - either an exact copy of the select list expression, the
alias, a 1-based number indicating the position of the column, or coln where n is a number
representing a column.
order_by_expression
Is a reference to a column in the select list - either an exact copy of the select list expression, the
alias, a 1-based number indicating the position of the column, or coln where n is a number
representing a column.
For more information on expressions, where they are used and how to create them, see Features
and Feature Collections .
ExecuteFeatureCollection
The ExecuteFeatureCollection method in the MICommand class is the bridge between the MapInfo
ADO.NET Data Provider and the Feature object model. This method executes command text (SQL
statements) against the data source connection, and builds an IResultSetFeatureCollection. The
Feature model is discussed in
Features and Feature Collections .