IResultSet.Absolute(Int32) Method

Definition

Moves the cursor to the given row number in this ResultSet object.

[Android.Runtime.Register("absolute", "(I)Z", "GetAbsolute_IHandler:Java.Sql.IResultSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public bool Absolute (int row);
[<Android.Runtime.Register("absolute", "(I)Z", "GetAbsolute_IHandler:Java.Sql.IResultSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member Absolute : int -> bool

Parameters

row
Int32

the number of the row to which the cursor should move. A value of zero indicates that the cursor will be positioned before the first row; a positive number indicates the row number counting from the beginning of the result set; a negative number indicates the row number counting from the end of the result set

Returns

true if the cursor is moved to a position in this ResultSet object; false if the cursor is before the first row or after the last row

Attributes

Exceptions

if a database error happens.

Remarks

Moves the cursor to the given row number in this ResultSet object.

If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.

If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the result set. For example, calling the method absolute(-1) positions the cursor on the last row; calling the method absolute(-2) moves the cursor to the next-to-last row, and so on.

If the row number specified is zero, the cursor is moved to before the first row.

An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before the first row or after the last row.

<B>Note:</B> Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().

Added in 1.2.

Java documentation for java.sql.ResultSet.absolute(int).

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

Applies to