Fetch Statements

A result set (or result table) is a set of table rows that is produced by a query (SQL SELECT command). Fetch statements are used to work with result sets. After the execution of a query in Silk Performer (the call of a SQL SELECT command), the result set is formed and the current position in the result set (cursor position) is set to the first row. We distinguish between two classes of fetch statements:

Fetch statements for sequentially fetching:

• Fetch next
• Fetch all

Fetch statements for direct positioning:

• Fetch row
• Fetch set
• Fetch last