Method absolute

Use

absolute is a method of theclass SapDB_ResultSet.

With this method you position the cursor within the result set to the record at the position pos.

Features

absolute (pos)

pos

Position of the data record you want to read in the result set

pos ? 1: Position is calculated from the beginning of the result set

pos = 1: First record in the result set

pos ? -1: Position is calculated from the end of the result set

pos = -1: Last record in the result set

Result:

?     Data record at the specified position in the result set

?     If the result set is empty/if pos exceeds the number of data records in the result set: None

Example

?     You position the cursor on the third record in the result set:

row = cursor.absolute (3)

?     You position the cursor on the second-to-last record in the result set:

row = cursor.absolute (-2)

?     Executing SQL Statements and Navigating in the Result Set