SQLSelect Methods |
The SQLSelect type exposes the following members.
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.) | |
AppendRow |
Insert the row that has been created in the buffer since the last SQLSelect:Append() operation.
| |
AsString |
Return the descriptive label defined for this data server.
(Inherited from DataServer.) | |
BindColumn | ||
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 |
Retrieve the contents of the specified column.
(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 |
Assign a value to a column in a data server.
(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).) | |
FLOCK |
This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.
(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.
| |
GetStatementOption |
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(Usual).) | |
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(Usual, Usual).) | |
NumResultCols |
Return the number of columns in the result set.
| |
PostInit |
Implement customized initialization code for the window.
(Inherited from DataServer.) | |
PreExecute |
Return the SQL command that is generated by X#.
| |
PreInit |
Implement customized initialization code for the server.
(Inherited from DataServer.) | |
Prepare |
Prepare the statement.
| |
Refresh |
Refresh the current row in the buffer, discarding any changes that have been made.
| |
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.) | |
ReReadRow | ||
ResetCursor | ||
ResetNotification |
Resume the broadcasting of Notify messages to the server's attached clients (after SQLSelect:SuspendNotification() has been called).
(Overrides ResetNotification.) | |
RLOCK |
This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.
(Overrides RLOCK(Usual).) | |
RLockVerify |
This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.
(Overrides RLockVerify.) | |
Rollback | (Overrides Rollback.) | |
Seek |
Move to the next record having a specified key value in the controlling order.
(Inherited from DataServer.) | |
SetColumnAttributes | ||
SetDataField | (Overrides SetDataField(Usual, Usual).) | |
SetPos | ||
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 |
Change a statement option.
| |
SetTimeStamp | ||
Skip |
Move forward or backward relative to the current row. (Similar to the Skip() function).
(Overrides Skip(Usual).) | |
SuspendNotification |
Suspend the broadcasting of Notify messages to the server's attached clients.
(Overrides SuspendNotification.) | |
Unlock |
This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.
| |
UnLock |
Remove all locks held on this data server.
(Inherited from DataServer.) | |
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.
| |
UpdateCursor | ||
UpdateKey | ||
UpdateVal |