SQLListPrimaryKeys Class (Typed) | ![]() |
Namespace: XSharp.VO.SDK
The SQLListPrimaryKeys type exposes the following members.
Name | Description | |
---|---|---|
![]() | SQLListPrimaryKeys |
Construct a SQLListPrimaryKeys 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 | (Inherited from SQLCatalogQuery.) |
![]() | 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 | (Inherited from SQLCatalogQuery.) |
![]() | AddDateVal | (Inherited from SQLSelect.) |
![]() | AddTimeString | (Inherited from SQLSelect.) |
![]() | Append | (Inherited from SQLCatalogQuery.) |
![]() ![]() | 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 | (Inherited from SQLCatalogQuery.) |
![]() ![]() | 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 | (Inherited from SQLCatalogQuery.) |
![]() | 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 | (Inherited from SQLCatalogQuery.) |
![]() | 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.) |