SQL Reader


Active Member
Licensed User
In the SQL there is a Reader component to read the rows from a SELECT statement.

- DataReader - Allows forward only access to the result of an executed command. The reading is done row after row.
I think it would be a great enhancement to SQL if there was a LinkedList to collect the IDs of each Row. This would happen after the SELECT and done automatically.

From the Linked List (containing a list of Ids of the Rows in the Table) we could then have built-in Procedures to use Next() and Previous() - First() Last().