MGDatabaseSetup.WhereClause   Go to object model Go to parent topic Go to previous topic

Description

Gets or sets the SQL Where clause that Autodesk MapGuide Server uses to query the OLE DB data source that provides data for this layer.

Returns an empty string if this property does not apply. If this property is modified successfully, it automatically sets the layer's rebuild flag to True. See Rebuild for details.

This property is equivalent to the MGMapLayer SQLWhere property.

Note

If you use the comparison operators =, <, >, <>, or <=, the value is assumed to be a string. Thus, numerical comparisons can return unexpected results. For example, if the SQL Where clause includes FEATURE_ID > 55, a row in the database table that has a feature ID of 6 would be returned, because the string "6" is greater than the string "55".

Note that for write operations, this property does not work during a busy state. For additional information, refer to "Handling Busy State and Map Refresh" chapter in the Autodesk MapGuide Developer's Guide.

Type

String (read/write)

Error Codes

-1 (busy): For write operations only.

See Also

getWhereClause, setWhereClause