SQLListStatistics Constructor | |
Construct a SQLListStatistics object.
Namespace:
VO
Assembly:
VOSQLClasses (in VOSQLClasses.dll) Version: 2.21
Syntax CONSTRUCTOR(
cQualifier,
cOwner,
cTableName,
nUnique,
nAccuracy,
oSQLConnection
) CLIPPER
[ClipperCallingConventionAttribute(new string[] { ... })]
public SQLListStatistics(
Usual cQualifier = default,
Usual cOwner = default,
Usual cTableName = default,
Usual nUnique = default,
Usual nAccuracy = default,
Usual oSQLConnection = default
)
Request Example
View SourceParameters
- cQualifier (Optional)
- Type: Usual
The search string or name of the table qualifier. - cOwner (Optional)
- Type: Usual
The search string or name of the table owner. - cTableName (Optional)
- Type: Usual
The search string or name of the table. - nUnique (Optional)
- Type: Usual
One of the following constants representing the type of index associated with the table: - nAccuracy (Optional)
- Type: Usual
One of the following constants representing the importance of the CARDINALITY and PAGES columns in the result set: - oSQLConnection (Optional)
- Type: Usual
The SQL connection indicating where the table can be found. If not specified, the current default connection is used, if any; if none is defined, the system asks the end user to log on to a database.
Remarks
To specify a search pattern, you can use the underscore (_) or percent (%) wildcard characters in the search string. An _ will match a single character and a % will match any sequence of 0 or more characters. The ESCAPE character (driver-defined) permits the _ and % characters to be used as literals. To obtain the ESCAPE character, you can call SQLConnection:Info(SQL_SEARCH_PATTERN_ESCAPE).
nUnique possible values:
Constant | Description |
---|
SQL_INDEX_ALL | Return all indexes. |
SQL_INDEX_UNIQUE | Return only the indexes that are unique. |
nAccuracy possible values:
Constant | Description |
---|
SQL_ENSURE | Requests that the driver unconditionally retrieves the statistics. |
SQL_QUICK | Requests that the driver retrieves results only if they are readily available from the server. In this case, the driver does not ensure that the values are current. |
See Also