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