Export (0) Print
Expand All

ResultSet Class

The ResultSet class provides access to a table of data generated by executing a Statement.


class ResultSet extends Object

Called

Method

Description

cancelTimeOut

Cancels a previous method call to the Object.setTimeOut Method. (Inherited from Object.)

close

Releases the object's database resources immediately.

equal

Determines whether the specified object is equal to the current one. (Inherited from Object.)

getBoolean

Retrieves the Boolean value of a column in the current row.

getByte

getDate

Retrieves the value of a column in the current row as an Microsoft Dynamics AXdate value.

getDateTime

getGuid

getInt

Retrieves the value of a column in the current row as an integer.

getInt64

getMetaData

getReal

Retrieves the value of a column in the current row as a value of the type real.

getString

Gets the string value of a column in the current row.

getTimeOutTimerHandle

Returns the timer handle for the object. (Inherited from Object.)

handle

Retrieves the handle of the class of the object. (Inherited from Object.)

new

Initializes a new instance of the Object Class. (Inherited from Object.)

next

Selects the first or subsequent row.

notify

Releases the hold on an object that has called a wait method on this object. (Inherited from Object.)

notifyAll

Releases a lock on the object that was issued by a wait method on this object. (Inherited from Object.)

objectOnServer

Determines whether the object is on a server. (Inherited from Object.)

owner

Returns the instance that owns the object. (Inherited from Object.)

setTimeOut

Sets up the scheduled execution of a specified method. (Inherited from Object.)

toString

Returns a string that represents the current object. (Inherited from Object.)

usageCount

Returns the current number of references (the value of the reference counter) that the object has. (Inherited from Object.)

wait

Pauses a process. (Inherited from Object.)

wasNull

Reports whether the last column read has the value SQL NULL.

xml

Returns an XML string that represents the current object. (Inherited from Object.)

For maximum portability, ResultSet columns within each row should be read in left-to-right order and each column should be read only once.

A ResultSet provides access to a table of data generated by executing a Statement Class instance. The table rows are retrieved in sequence. Within a row its column values can be accessed in any order.

A ResultSet maintains a cursor that points to its current row of data. Initially the cursor is positioned before the first row. The 'next' method moves the cursor to the next row.

For the getXX methods, Microsoft Dynamics AX attempts to convert the underlying data to the specified type and returns a suitable value.

The getXX (for example,. ResultSet.getInt Method) methods retrieve column values for the current row. You retrieve values using the index number of the column. Columns are numbered from 1.

A ResultSet is automatically closed by the statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results.

static void example()
{
    Connection Con;
    Statement Stmt;
    ResultSet R;
    SqlStatementExecutePermission perm;
    str sql = 'SELECT VALUE FROM SQLSYSTEMVARIABLES';
    ;
    Con = new Connection();
    Stmt = Con.createStatement();
    perm = new SqlStatementExecutePermission(sql);
    perm.assert();
    R = Stmt.executeQuery(sql);

    while ( R.next() )
    {
        print R.getString(1);
    }
}

Community Additions

ADD
Show:
© 2014 Microsoft