SQLCatalogQuery Class (Typed) |
Namespace: XSharp.VO.SDK
The SQLCatalogQuery type exposes the following members.
Name | Description | |
---|---|---|
SQLCatalogQuery |
Construct an SQLCatalogQuery object.
|
Name | Description | |
---|---|---|
AppendData | (Inherited from SQLSelect.) | |
AppendFlag | **Missing documentation ** (Inherited from SQLSelect.) | |
BatchUpdates | (Inherited from SQLSelect.) | |
BoF |
A logical value indicating whether the server is positioned at the beginning of the result set, on the first row.
(Inherited from SQLSelect.) | |
Clients | **Missing documentation ** (Inherited from DataServer.) | |
Collection | ||
ConcurrencyControl |
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.) | |
Connection |
The SQL connection object that the SQLSelect is using to manipulate the result set.
(Inherited from SQLSelect.) | |
CursorName |
A string containing the cursor name.
(Inherited from SQLSelect.) | |
DBStruct |
An array containing the structure of this data server.
(Inherited from SQLSelect.) | |
Deleted |
A logical value indicating whether the current row has been deleted.
(Inherited from SQLSelect.) | |
EoF |
A logical value indicating whether the server is positioned at the end of the result set, after the last row.
(Inherited from SQLSelect.) | |
ErrInfo |
An SQLErrorInformation object.
(Inherited from SQLSelect.) | |
FCount |
The number of columns in the result set. A value of -1 indicates an error.
(Inherited from SQLSelect.) | |
FOUND |
A logical value indicating whether the previous search operation succeeded.
(Inherited from SQLSelect.) | |
HLStatus | **Missing documentation ** (Inherited from DataServer.) | |
HyperLabel | (Inherited from SQLSelect.) | |
IndexColumns | (Inherited from SQLSelect.) | |
LastRec | (Inherited from SQLSelect.) | |
lRowModified | (Inherited from SQLSelect.) | |
Modified | (Inherited from SQLSelect.) | |
MoreResults |
A logical value representing whether there are more rows to retrieve.
(Inherited from SQLSelect.) | |
Name |
A string representing the name of this data server.
(Inherited from DataServer.) | |
NameSym |
A symbol representing the name of this data server.
(Inherited from DataServer.) | |
NativeSQL |
A string containing the native SQL text of the statement.
Level 2
(Inherited from SQLSelect.) | |
NullAsBlank |
A logical value determining whether SQL NULL values are strongly typed (TRUE) or not (FALSE, default value).
(Inherited from SQLSelect.) | |
NumCols | (Inherited from SQLSelect.) | |
NumParameters |
A numeric value containing the number of parameters. A value of -1 indicates an error.
Level 2
(Inherited from SQLSelect.) | |
NumResultColumns |
A numeric value containing the number of columns in the result set.
(Inherited from SQLSelect.) | |
NumSuccessfulRows |
A numeric value containing the number of rows that were modified by a delete, append, or update operation.
(Inherited from SQLSelect.) | |
PrepFlag |
A logical value that indicates if the select statement has been prepared.
(Inherited from SQLSelect.) | |
ReadOnly | (Inherited from SQLSelect.) | |
RecCount |
A numeric value representing the number of rows in the data server.
(Inherited from SQLSelect.) | |
RecNo | (Inherited from SQLSelect.) | |
SQLColumns | **Missing documentation ** (Inherited from SQLSelect.) | |
SqlData | **Missing documentation ** (Inherited from SQLSelect.) | |
SQLString |
A string representing the SQL statement text.
(Inherited from SQLSelect.) | |
Statement |
A SQL statement object.
(Inherited from SQLSelect.) | |
StatementHandle |
A numeric value representing the statement handle.
(Inherited from SQLSelect.) | |
Status |
A hyperlabel object identifying the status after the last operation.
(Inherited from SQLSelect.) | |
TableName |
A string representing the name of the table.
(Inherited from SQLSelect.) | |
TimeStampAsDate | **Missing documentation ** (Inherited from SQLSelect.) | |
Used |
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.) |
Name | Description | |
---|---|---|
_Open | ||
AddDateVal | (Inherited from SQLSelect.) | |
AddTimeString | (Inherited from SQLSelect.) | |
Append | ||
Append(Logic) |
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.) | |
AppendRow |
Insert the row that has been created in the buffer since the last SQLSelect:Append() operation.
(Inherited from SQLSelect.) | |
AsString |
Return the descriptive label defined for this data server.
(Inherited from DataServer.) | |
BindColumn | Obsolete. (Inherited from SQLSelect.) | |
Close |
Close the cursor corresponding to the server. Note that the database connection is not closed, only the cursor.
(Inherited from SQLSelect.) | |
Column |
Return a specified SQL column.
(Inherited from SQLSelect.) | |
ColumnAttributes |
Return the SQL column attributes for a specified column.
(Inherited from SQLSelect.) | |
Commit |
Save the changes (updates and deletes) made since the last Commit().
(Inherited from SQLSelect.) | |
DataField |
Return the data (DataField object) at a specified column position.
(Inherited from SQLSelect.) | |
Delete |
Delete the current row.
(Inherited from SQLSelect.) | |
DirectSkip | (Inherited from SQLSelect.) | |
Error |
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.) | |
Execute | ||
Execute(Usual) |
Open the cursor.
(Inherited from SQLSelect.) | |
ExtendedFetch |
Provide extended fetch capabilities, specifying type and row.
(Inherited from SQLSelect.) | |
Fetch |
Fetch the next row.
(Inherited from SQLSelect.) | |
FieldGet | (Inherited from SQLSelect.) | |
FieldGetFormatted |
Retrieve the contents of the specified column according to the formatting specifications of its field specification.
(Inherited from SQLSelect.) | |
FieldHyperLabel |
Return the hyperlabel of a specified column.
(Inherited from SQLSelect.) | |
FieldInfo |
Retrieve information about or set an alias for the indicated column.
(Inherited from SQLSelect.) | |
FieldName |
Return the name of a specified column. Note that the column's hyperlabel also contains a name.
(Inherited from SQLSelect.) | |
FieldPos |
Return the position of a specified column within the data server, as a number starting with 1.
(Inherited from SQLSelect.) | |
FieldPut | (Overrides FieldPut(Usual, Usual).) | |
FieldSpec |
Return the field specification object for the indicated column.
(Inherited from SQLSelect.) | |
FieldStatus |
Return a hyperlabel object identifying the status after the last operation.
(Inherited from SQLSelect.) | |
FieldSym |
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.) | |
FieldValidate |
Validate the provided value according to the validation rules of the indicated column's FieldSpec.
(Inherited from SQLSelect.) | |
FLock | (Inherited from SQLSelect.) | |
FreeStmt |
Free the statement, according to the specified option.
(Inherited from SQLSelect.) | |
GetData |
Retrieve the contents of the specified column.
(Inherited from SQLSelect.) | |
GetdateVal | (Inherited from SQLSelect.) | |
GetLookupTable |
Retrieve a two-column array of values from two fields in the server.
(Inherited from SQLSelect.) | |
GetStatementOption | Obsolete.
Retrieve the current setting for a statement option.
(Inherited from SQLSelect.) | |
GetTimeStamp | (Inherited from SQLSelect.) | |
GetTimeString | (Inherited from SQLSelect.) | |
GoBottom |
Position the data server on the last row.
(Inherited from SQLSelect.) | |
GoTo |
Position the data server on the specified row number.
(Inherited from SQLSelect.) | |
GoTop |
Position the data server on the first row.
(Inherited from SQLSelect.) | |
LockCurrentRecord | (Inherited from DataServer.) | |
NoIVarGet |
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.
(Inherited from SQLSelect.)Important! NoIVarGet() should not be called directly; it is called by the system for handling invalid references. | |
NoIVarPut |
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.
(Inherited from SQLSelect.)Important! NoIVarPut() should not be called directly; it is called by the system for handling invalid references. | |
Notify |
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.) | |
NumResultCols |
Return the number of columns in the result set.
(Inherited from SQLSelect.) | |
PostInit |
Implement customized initialization code for the window.
(Inherited from DataServer.) | |
PreExecute |
Return the SQL command that is generated by X#.
(Inherited from SQLSelect.) | |
PreInit |
Implement customized initialization code for the server.
(Inherited from DataServer.) | |
Prepare | (Overrides Prepare.) | |
Refresh |
Refresh the current row in the buffer, discarding any changes that have been made.
(Inherited from SQLSelect.) | |
RegisterClient |
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.) | |
RejectChanges | (Inherited from SQLSelect.) | |
Requery | (Inherited from SQLSelect.) | |
ReReadRow | (Inherited from SQLSelect.) | |
ResetCursor | (Inherited from SQLSelect.) | |
ResetNotification |
Resume the broadcasting of Notify messages to the server's attached clients (after SQLSelect:SuspendNotification() has been called).
(Inherited from SQLSelect.) | |
RLock | (Inherited from SQLSelect.) | |
RLockVerify |
This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.
(Inherited from SQLSelect.) | |
Rollback |
Undo the changes (updates and deletes) made since the last Commit().
(Inherited from SQLSelect.) | |
Seek |
Move to the next record having a specified key value in the controlling order.
(Inherited from DataServer.) | |
SetColumnAttributes | (Inherited from SQLSelect.) | |
SetDataField | (Inherited from SQLSelect.) | |
SetPos | Obsolete. (Inherited from SQLSelect.) | |
SetPrimaryKey |
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.) | |
SetStatementOption | Obsolete.
Change a statement option.
(Inherited from SQLSelect.) | |
SetTimeStamp | (Inherited from SQLSelect.) | |
ShowSQLError | (Inherited from SQLSelect.) | |
Skip |
Move forward or backward relative to the current row. (Similar to the Skip() function).
(Inherited from SQLSelect.) | |
SuspendNotification |
Suspend the broadcasting of Notify messages to the server's attached clients.
(Inherited from SQLSelect.) | |
UnLock | (Inherited from SQLSelect.) | |
UnRegisterClient |
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.) | |
Update |
Update this server with data from another server or table.
(Inherited from DataServer.) | |
Update(Usual) |
Update the current row or restore the original values of the row.
(Inherited from SQLSelect.) | |
UpdateCursor | Obsolete. (Inherited from SQLSelect.) | |
UpdateKey | Obsolete. (Inherited from SQLSelect.) | |
UpdateVal | Obsolete. (Inherited from SQLSelect.) |