SQLSelect Methods (Typed) |
|
The SQLSelect type exposes the following members.
Functions| Name | Description | |
|---|---|---|
 | AddDateVal | |
| AddTimeString | |
 | Append |
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.
(Overrides Append(Logic).) |
| AppendRow |
Insert the row that has been created in the buffer since the last SQLSelect:Append() operation.
|
| BindColumn | Obsolete. |
| Close |
Close the cursor corresponding to the server. Note that the database connection is not closed, only the cursor.
(Overrides Close.) |
| Column |
Return a specified SQL column.
|
| ColumnAttributes |
Return the SQL column attributes for a specified column.
|
| Commit |
Save the changes (updates and deletes) made since the last Commit().
(Overrides Commit.) |
| DataField |
Return the data (DataField object) at a specified column position.
(Overrides DataField(Usual).) |
| Delete |
Delete the current row.
(Overrides Delete.) |
| DirectSkip | |
| 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.
|
| Execute |
Open the cursor.
|
| ExtendedFetch |
Provide extended fetch capabilities, specifying type and row.
|
| Fetch |
Fetch the next row.
|
| FieldGet | (Overrides FieldGet(Usual).) |
| FieldGetFormatted |
Retrieve the contents of the specified column according to the formatting specifications of its field specification.
(Overrides FieldGetFormatted(Usual).) |
| FieldHyperLabel |
Return the hyperlabel of a specified column.
(Overrides FieldHyperLabel(Usual).) |
| FieldInfo |
Retrieve information about or set an alias for the indicated column.
|
| FieldName |
Return the name of a specified column. Note that the column's hyperlabel also contains a name.
(Overrides FieldName(Usual).) |
| FieldPos |
Return the position of a specified column within the data server, as a number starting with 1.
(Overrides FieldPos(Usual).) |
| FieldPut | (Overrides FieldPut(Usual, Usual).) |
| FieldSpec |
Return the field specification object for the indicated column.
(Overrides FieldSpec(Usual).) |
| FieldStatus |
Return a hyperlabel object identifying the status after the last operation.
(Overrides FieldStatus(Usual).) |
| 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.
(Overrides FieldSym(Usual).) |
| FieldValidate |
Validate the provided value according to the validation rules of the indicated column's FieldSpec.
(Overrides FieldValidate(Usual, Usual).) |
 | FindTableName | |
| FLock | (Overrides FLock.) |
| FreeStmt |
Free the statement, according to the specified option.
|
| GetData |
Retrieve the contents of the specified column.
|
| GetdateVal | |
| GetLookupTable |
Retrieve a two-column array of values from two fields in the server.
(Overrides GetLookupTable(Usual, Usual, Usual, Usual).) |
| GetStatementOption | Obsolete.
Retrieve the current setting for a statement option.
|
| GetTimeStamp | |
| GetTimeString | |
| GoBottom |
Position the data server on the last row.
(Overrides GoBottom.) |
| GoTo |
Position the data server on the specified row number.
(Overrides GoTo(Long).) |
| GoTop |
Position the data server on the first row.
(Overrides GoTop.) |
| 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.
(Overrides NoIVarGet(Usual).)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.
(Overrides NoIVarPut(Usual, Usual).)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.
(Overrides Notify(Long, Usual).) |
| NumResultCols |
Return the number of columns in the result set.
|
| PreExecute |
Return the SQL command that is generated by X#.
|
| Prepare |
Prepare the statement.
|
| Refresh |
Refresh the current row in the buffer, discarding any changes that have been made.
|
| RejectChanges | |
| Requery | |
| ReReadRow | |
| ResetCursor | |
| ResetNotification |
Resume the broadcasting of Notify messages to the server's attached clients (after SQLSelect:SuspendNotification() has been called).
(Overrides ResetNotification.) |
| RLock | (Overrides RLock(Long).) |
| RLockVerify |
This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.
(Overrides RLockVerify.) |
| Rollback |
Undo the changes (updates and deletes) made since the last Commit().
(Overrides Rollback.) |
| SetColumnAttributes | |
| SetDataField | (Overrides SetDataField(DWord, DataField).) |
| SetPos | Obsolete. |
| 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).
|
| SetStatementOption | Obsolete.
Change a statement option.
|
| SetTimeStamp | |
| ShowSQLError | |
| Skip |
Move forward or backward relative to the current row. (Similar to the Skip() function).
(Overrides Skip(Long).) |
| SuspendNotification |
Suspend the broadcasting of Notify messages to the server's attached clients.
(Overrides SuspendNotification.) |
| UnLock | (Overrides UnLock(Long).) |
| Update |
Update the current row or restore the original values of the row.
|
| UpdateCursor | Obsolete. |
| UpdateKey | Obsolete. |
| UpdateVal | Obsolete. |
See Also