Click or drag to resize

SQLListStatistics Constructor

X#
Construct a SQLListStatistics object.

Namespace:  VO
Assembly:  VOSQLClasses (in VOSQLClasses.dll) Version: 2.19
Syntax
 CONSTRUCTOR(
	cQualifier,
	cOwner,
	cTableName,
	nUnique,
	nAccuracy,
	oSQLConnection
) CLIPPER
Request Example View Source

Parameters

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:
ConstantDescription
SQL_INDEX_ALLReturn all indexes.
SQL_INDEX_UNIQUEReturn only the indexes that are unique.
nAccuracy possible values:
ConstantDescription
SQL_ENSURERequests that the driver unconditionally retrieves the statistics.
SQL_QUICKRequests 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