User`s guide

6 Using Database Toolbox Functions
6-66
The columns in curs.Data are:
• Product number
• Stock number
• Supplier number
• Unit cost
• Product description
Display the position of the cursor.
curs.Position
ans =
5
The position of the cursor stays at the absolute position offset 5.
Retrieve Data Using a Relative Position Offset
Import the data for three products in the data set using the relative position offset 5. A
scrollable cursor adds the current position offset 5 to the specified relative position offset
5. The scrollable cursor advances to cursor position 10 and imports data.
curs = fetch(curs,3,'relativePosition',5);
Display the data for the three products.
curs.Data
ans =
[10] [888652] [1006] [24] 'Teddy Bear'
[11] [408143] [1004] [11] 'Convertible'
[12] [210456] [1010] [22] 'Hugsy'
Display the position of the cursor.
curs.Position
ans =
10