DatabaseQuery.SelectStatement Property
Gets or sets a SQL SELECT statement.
Thread safety: This property is not thread-safe. Show
Syntax
public AttributeVariable< System.String > SelectStatement { get; set; }Property Value
Type: An attribute variable that returns a value of type String (not available in C#).
Default: ""
A SQL SELECT statement that replaces the default statement used by the dataset.
Default: ""
A SQL SELECT statement that replaces the default statement used by the dataset.
Remarks
Completely replaces the SQL SELECT statement used to fetch features from the database.
The first column is used as the feature id, the second column and the following, up to the next to last, is set as feature attributes. The last column is expected to contain geometry data in well-known binary (WKB) format.
SELECT :keyColumn, :attributeList, :geometryColumn.STAsBinary()
FROM :tableName
WHERE :geometryColumn.STIntersects(geometry::STPolyFromText(:wktArea, :sridString)) = 1
SELECT :keyColumn, :attributeList, AsBinary(:geometryColumn)
FROM :tableName
WHERE Intersects(:geometryColumn, PolygonFromText(:wktArea, :sridString))
SELECT :tableName.":keyColumn", :attributeList, :tableName.":geometryColumn"
FROM :tableName :tableName
WHERE SDO_FILTER(
:tableName.":geometryColumn",
MDSYS.SDO_GEOMETRY(
2003,
:sridString,
NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),
MDSYS.SDO_ORDINATE_ARRAY($xMin,$yMin, $xMax,$yMax)),
'querytype = WINDOW') = 'TRUE'
SELECT :keyColumn, :attributeList, ST_AsBinary(:geometryColumn)
FROM :tableName
WHERE ST_Intersects(:geometryColumn::geometry, ST_GeomFromText(:wktArea, :sridString))
Platforms
Windows, Linux, Android