SQLSelect Methods

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.

Insert the row that has been created in the buffer since the last SQLSelect:Append() operation.

Return the descriptive label defined for this data server.

Close the cursor corresponding to the server. Note that the database connection is not closed, only the cursor.

Return a specified SQL column.

Return the SQL column attributes for a specified column.

Save the changes (updates and deletes) made since the last Commit().

Return the data (DataField object) at a specified column position.

Delete the current row.

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.

Open the cursor.

Provide extended fetch capabilities, specifying type and row.

Fetch the next row.

Retrieve the contents of the specified column.

Retrieve the contents of the specified column according to the formatting specifications of its field specification.

Return the hyperlabel of a specified column.

Retrieve information about or set an alias for the indicated column.

Return the name of a specified column. Note that the column's hyperlabel also contains a name.

Return the position of a specified column within the data server, as a number starting with 1.

Assign a value to a column in a data server.

Return the field specification object for the indicated column.

Return a hyperlabel object identifying the status after the last operation.

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.

Validate the provided value according to the validation rules of the indicated column's FieldSpec.

This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.

Free the statement, according to the specified option.

Retrieve the contents of the specified column.

Retrieve a two-column array of values from two fields in the server.

Retrieve the current setting for a statement option.

Position the data server on the last row.

Position the data server on the specified row number.

Position the data server on the first row.

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.
Important! NoIVarGet() should not be called directly; it is called by the system for handling invalid references.

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.
Important! NoIVarPut() should not be called directly; it is called by the system for handling invalid references.

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.

Return the number of columns in the result set.

Implement customized initialization code for the window.

Return the SQL command that is generated by X#.

Implement customized initialization code for the server.

Prepare the statement.

Refresh the current row in the buffer, discarding any changes that have been made.

Register an object as a client of this data server, so that it receives notification messages from the server about certain actions.

Resume the broadcasting of Notify messages to the server's attached clients (after SQLSelect:SuspendNotification() has been called).

This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.

This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.

Move to the next record having a specified key value in the controlling order.

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).

Change a statement option.

Move forward or backward relative to the current row. (Similar to the Skip() function).

Suspend the broadcasting of Notify messages to the server's attached clients.

This method is provided to override the inherited functionality from the DataServer class, as it does not apply to SQLSelect.

Remove all locks held on this data server.

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.

Update this server with data from another server or table.

Update the current row or restore the original values of the row.