ADO and SQL Server

ORDER BY Columns in Select List Property

The ORDER BY Columns in Select List property indicates whether columns in an ORDER BY clause must be included in the SELECT statement.

Applies To
Connection Object

Syntax

object.Properties("ORDER BY Columns in Select List")

Parts

object

Expression that evaluates to an object in the Applies To list.

Returns

One of the following settings:

Value Description
True Columns in an ORDER BY clause must be included in the SELECT statement.
False Columns in an ORDER BY clause are not required to be included in the SELECT statement.

Data Type

adBoolean

Modifiable

Read-only

OLE DB Property

DBPROP_ORDERBYCOLUMNSINSELECT