SQLListViews Methods (Typed) |
The SQLListViews type exposes the following members.
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.) |