Method relative

Use

relative is a method of theclass SapDB_ResultSet.

With this method you position the cursor on a data record which is located a certain number of data records back/forward in the result set.

Features

relative (offset)

offset

Number of data records back or forward relative to the current position that the cursor should be moved

offset > 0: You move the cursor forwards in the result set

offset < 0: You move the cursor backwards in the result set

Result:

?     Data record at the specified position in the result set

?     If the result set is empty/if offset is greater than the number of data records back/forward from the current cursor position: None

Example

?     You move the cursor 5 data records forward:

row = cursor.relative (5)

?     You move the cursor 1 data record back:

row = cursor.relative (-1)

This expression is equivalent to row = cursor.previous ().

?     Executing SQL Statements and Navigating in the Result Set