Click or drag to resize

SQLListStatistics Class

X#
List the table statistics and the indexes.
Inheritance Hierarchy
Object
  DataServer
    SQLSelect
      SQLCatalogQuery
        SQLListStatistics

Namespace:  VO
Assembly:  VOSQLClasses (in VOSQLClasses.dll) Version: 2.19
Syntax
 CLASS SQLListStatistics INHERIT SQLCatalogQuery
Request Example View Source

The SQLListStatistics type exposes the following members.

Constructors
  NameDescription
Public methodSQLListStatistics
Construct a SQLListStatistics object.
Top
Properties
  NameDescription
Public propertyAppendData (Inherited from SQLSelect.)
Public propertyAppendFlag
**Missing documentation **
(Inherited from SQLSelect.)
Public propertyBoF
A logical value indicating whether the server is positioned at the beginning of the result set, on the first row.
(Inherited from SQLSelect.)
Public propertyBoundedColumns
**Missing documentation **
(Inherited from SQLSelect.)
Public propertyClients
**Missing documentation **
(Inherited from DataServer.)
Public propertyConcurrencyControl
A constant, identifying the mode of automatic concurrency control for this data server, determining when and how records are locked and released:
(Inherited from DataServer.)
Public propertyConnection
The SQL connection object that the SQLSelect is using to manipulate the result set.
(Inherited from SQLSelect.)
Public propertyCursorName
This property is provided to override the inherited functionality from the SQLSelect class, as it does not apply to SQLCatalogQuery.
(Inherited from SQLCatalogQuery.)
Public propertyCursorType
A constant, which describes the cursor type used by the SQL statement:
(Inherited from SQLSelect.)
Public propertyDBStruct
An array containing the structure of this data server.
(Inherited from SQLSelect.)
Public propertyDeleted
A logical value indicating whether the current row has been deleted.
(Inherited from SQLSelect.)
Public propertyEoF
A logical value indicating whether the server is positioned at the end of the result set, after the last row.
(Inherited from SQLSelect.)
Public propertyErrInfo
An SQLErrorInformation object.
(Inherited from SQLSelect.)
Public propertyFCount
The number of columns in the result set. A value of -1 indicates an error.
(Inherited from SQLSelect.)
Public propertyFOUND
A logical value indicating whether the previous search operation succeeded.
(Inherited from SQLSelect.)
Public propertyHLStatus
**Missing documentation **
(Inherited from DataServer.)
Public propertyCode exampleHyperLabel
The hyperlabel connected to this data server. From the hyperlabel, you can retrieve additional information about the data server
(Inherited from DataServer.)
Public propertyIndexColumns (Inherited from SQLSelect.)
Public propertyLASTREC
**Missing documentation **
(Inherited from SQLSelect.)
Public propertyModified (Inherited from SQLSelect.)
Public propertyMoreResults
A logical value representing whether there are more rows to retrieve.
(Inherited from SQLSelect.)
Public propertyName
A string representing the name of this data server.
(Inherited from DataServer.)
Public propertyNameSym
A symbol representing the name of this data server.
(Inherited from DataServer.)
Public propertyNativeSQL
A string containing the native SQL text of the statement. Level 2
(Inherited from SQLSelect.)
Public propertyNullAsBlank
A logical value determining whether SQL NULL values are strongly typed (TRUE) or not (FALSE, default value).
(Inherited from SQLSelect.)
Public propertyNumCols (Inherited from SQLSelect.)
Public propertyNumParameters
A numeric value containing the number of parameters. A value of -1 indicates an error. Level 2
(Inherited from SQLSelect.)
Public propertyNumResultColumns
A numeric value containing the number of columns in the result set.
(Inherited from SQLSelect.)
Public propertyNumSuccessfulRows
A numeric value containing the number of rows that were modified by a delete, append, or update operation.
(Inherited from SQLSelect.)
Public propertyPrepFlag
A logical value that indicates if the select statement has been prepared.
(Inherited from SQLSelect.)
Public propertyRecCount
A numeric value representing the number of rows in the data server.
(Inherited from SQLSelect.)
Public propertyCode exampleRecno
A numeric value representing the relative position in the data server.
(Inherited from SQLSelect.)
Public propertyRecNo
A numeric value representing the current record number, identifying the position of the record pointer in this data server.
(Inherited from DataServer.)
Public propertyRowCount (Inherited from SQLSelect.)
Public propertyScrollConcurrency
A constant, which describes the concurrency mode used by the SQL statement:
(Inherited from SQLSelect.)
Public propertyScrollUpdateType
A constant, which describes the type of SQL statement to use during append, update or delete operations.
(Inherited from SQLSelect.)
Public propertySimulateCursor
A constant, which describes the way the ODBC drivers tries to guarantee that update or delete statements only affect one single row.
(Inherited from SQLSelect.)
Public propertySQLColumns
**Missing documentation **
(Inherited from SQLSelect.)
Public propertySqlData
**Missing documentation **
(Inherited from SQLSelect.)
Public propertySQLString
A string representing the SQL statement text.
(Inherited from SQLSelect.)
Public propertyStatement
A SQL statement object.
(Inherited from SQLSelect.)
Public propertyStatementHandle
A numeric value representing the statement handle.
(Inherited from SQLSelect.)
Public propertyCode exampleStatus
A hyperlabel object identifying the status after the last operation.
(Inherited from SQLSelect.)
Public propertyTableName
This property is provided to override the inherited functionality from the SQLSelect class, as it does not apply to SQLCatalogQuery.
(Inherited from SQLCatalogQuery.)
Public propertyTimeStampAsDate
**Missing documentation **
(Inherited from SQLSelect.)
Public propertyUsed
A logical value indicating whether the current query is active. It returns TRUE if the current query is active; otherwise, it returns FALSE.
(Inherited from SQLSelect.)
Top
Methods
  NameDescription
Public methodAddDateVal (Inherited from SQLSelect.)
Public methodAddTimeString (Inherited from SQLSelect.)
Public methodCode exampleAppend
Create a blank row in the buffer; this blank row becomes the current position and is ready for assignment of data values. The SQLSelect:RecNo of this buffer is SQLSelect:RecCount+1.
(Inherited from SQLSelect.)
Public methodAppendRow
Insert the row that has been created in the buffer since the last SQLSelect:Append() operation.
(Inherited from SQLSelect.)
Public methodAsString
Return the descriptive label defined for this data server.
(Inherited from DataServer.)
Public methodBindColumn (Inherited from SQLSelect.)
Public methodClose
Close the cursor corresponding to the server. Note that the database connection is not closed, only the cursor.
(Inherited from SQLSelect.)
Public methodColumn
Return a specified SQL column.
(Inherited from SQLSelect.)
Public methodColumnAttributes
Return the SQL column attributes for a specified column.
(Inherited from SQLSelect.)
Public methodCommit
Save the changes (updates and deletes) made since the last Commit().
(Inherited from SQLSelect.)
Public methodDataField
Return the data (DataField object) at a specified column position.
(Inherited from SQLSelect.)
Public methodDelete
This method is provided to override the inherited functionality from the SQLSelect class, as it does not apply to SQLCatalogQuery; therefore it generates an error and returns FALSE.
(Inherited from SQLCatalogQuery.)
Public methodDirectSkip (Inherited from SQLSelect.)
Public methodError
Provide a method for handling error conditions raised during database processing. This is an event handler: it is automatically called by other methods; the developer does not normally need to call the error method, but might want to replace or amend it.
(Inherited from SQLSelect.)
Public methodExecute
Retrieve the list of statistics about a table and indexes associated with the table.
(Overrides Execute.)
Public methodCode exampleExecute(Usual)
Open the cursor.
(Inherited from SQLSelect.)
Public methodExtendedFetch
Provide extended fetch capabilities, specifying type and row.
(Inherited from SQLSelect.)
Public methodFetch
Fetch the next row.
(Inherited from SQLSelect.)
Public methodFIELDGET
Retrieve the contents of the specified column.
(Inherited from SQLSelect.)
Public methodFieldGetFormatted
Retrieve the contents of the specified column according to the formatting specifications of its field specification.
(Inherited from SQLSelect.)
Public methodFieldHyperLabel
Return the hyperlabel of a specified column.
(Inherited from SQLSelect.)
Public methodFieldInfo
Retrieve information about or set an alias for the indicated column.
(Inherited from SQLSelect.)
Public methodFieldName
Return the name of a specified column. Note that the column's hyperlabel also contains a name.
(Inherited from SQLSelect.)
Public methodFieldPos
Return the position of a specified column within the data server, as a number starting with 1.
(Inherited from SQLSelect.)
Public methodFIELDPUT
This method is provided to override the inherited functionality from the SQLSelect class, as it does not apply to SQLCatalogQuery; therefore it generates an error and returns FALSE.
(Inherited from SQLCatalogQuery.)
Public methodFIELDPUT(Usual, Usual)
Assign a value to a column in a data server.
(Inherited from SQLSelect.)
Public methodFieldSpec
Return the field specification object for the indicated column.
(Inherited from SQLSelect.)
Public methodFieldStatus
Return a hyperlabel object identifying the status after the last operation.
(Inherited from SQLSelect.)
Public methodFieldSym
Return the symbolic name of a specified column. Note that the column's hyperlabel also contains a name; these two names are the same in the code generated by the SQL Editor.
(Inherited from SQLSelect.)
Public methodFieldValidate
Validate the provided value according to the validation rules of the indicated column's FieldSpec.
(Inherited from SQLSelect.)
Public methodFLOCK
This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.
(Inherited from SQLSelect.)
Public methodFreeStmt
Free the statement, according to the specified option.
(Inherited from SQLSelect.)
Public methodGetData
Retrieve the contents of the specified column.
(Inherited from SQLSelect.)
Public methodGetdateVal (Inherited from SQLSelect.)
Public methodCode exampleGetLookupTable
Retrieve a two-column array of values from two fields in the server.
(Inherited from SQLSelect.)
Public methodGetStatementOption
Retrieve the current setting for a statement option.
(Inherited from SQLSelect.)
Public methodGetTimeStamp (Inherited from SQLSelect.)
Public methodGetTimeString (Inherited from SQLSelect.)
Public methodCode exampleGoBottom
Position the data server on the last row.
(Inherited from SQLSelect.)
Public methodGoTo
Position the data server on the specified row number.
(Inherited from SQLSelect.)
Public methodGoTop
Open the query and fetch the first result.
(Inherited from SQLCatalogQuery.)
Public methodNoIVarGet
Provide a general error interception that is automatically called (in any class) whenever an access reference is made to a non-existent exported instance variable. In the SQLSelect class, it is used to implement the virtual column variable.
Important! NoIVarGet() should not be called directly; it is called by the system for handling invalid references.
(Inherited from SQLSelect.)
Public methodNoIVarPut
Provide a general error interception that is automatically called (in any class) whenever an assignment reference is made to a non-existent exported instance variable.
Important! NoIVarPut() should not be called directly; it is called by the system for handling invalid references.
(Inherited from SQLSelect.)
Public methodNotify
Provide a method that is automatically called by the action methods of the server after completion of some significant event: a column has changed, the server position has changed, some operation has been completed. Its standard implementation is to broadcast the same notification to its attached clients.
(Inherited from SQLSelect.)
Public methodNumResultCols
Return the number of columns in the result set.
(Inherited from SQLSelect.)
Public methodPostInit
Implement customized initialization code for the window.
(Inherited from DataServer.)
Public methodCode examplePreExecute
Return the SQL command that is generated by X#.
(Inherited from SQLSelect.)
Public methodPreInit
Implement customized initialization code for the server.
(Inherited from DataServer.)
Public methodRefresh
Refresh the current row in the buffer, discarding any changes that have been made.
(Inherited from SQLSelect.)
Public methodRegisterClient
Register an object as a client of this data server, so that it receives notification messages from the server about certain actions.
(Inherited from DataServer.)
Public methodReReadRow (Inherited from SQLSelect.)
Public methodResetCursor (Inherited from SQLSelect.)
Public methodResetNotification
Resume the broadcasting of Notify messages to the server's attached clients (after SQLSelect:SuspendNotification() has been called).
(Inherited from SQLSelect.)
Public methodRLOCK
This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.
(Inherited from SQLSelect.)
Public methodRLockVerify
This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.
(Inherited from SQLSelect.)
Public methodRollback (Inherited from SQLSelect.)
Public methodSeek
Move to the next record having a specified key value in the controlling order.
(Inherited from DataServer.)
Public methodSetColumnAttributes (Inherited from SQLSelect.)
Public methodSetDataField (Inherited from SQLSelect.)
Public methodSetPos (Inherited from SQLSelect.)
Public methodSetPrimaryKey
Specify a column to be used as a unique index in searched updates or deletes that require a key (i.e., SQLSelect:ScrollUpdateType = SQL_SC_UPD_KEY).
(Inherited from SQLSelect.)
Public methodSetStatementOption
Change a statement option.
(Inherited from SQLSelect.)
Public methodSetTimeStamp (Inherited from SQLSelect.)
Public methodSkip
Fetch a new row of the result set.
(Inherited from SQLCatalogQuery.)
Public methodSuspendNotification
Suspend the broadcasting of Notify messages to the server's attached clients.
(Inherited from SQLSelect.)
Public methodUnlock
This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.
(Inherited from SQLSelect.)
Public methodUnLock
Remove all locks held on this data server.
(Inherited from DataServer.)
Public methodUnRegisterClient
Remove the registration of an object as a client of this data server, so that it no longer receives notification messages from the server about certain actions.
(Inherited from DataServer.)
Public methodUpdate
This method is provided to override the inherited functionality from the SQLSelect class, as it does not apply to SQLCatalogQuery; therefore it generates an error and returns FALSE.
(Inherited from SQLCatalogQuery.)
Public methodUpdate(Usual)
Update the current row or restore the original values of the row.
(Inherited from SQLSelect.)
Public methodUpdateCursor (Inherited from SQLSelect.)
Public methodUpdateKey (Inherited from SQLSelect.)
Public methodUpdateVal (Inherited from SQLSelect.)
Top
Fields
See Also

Reference