Pitney Bowes MapXtreme User 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
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