BPak Active Member Licensed User Longtime User Jan 27, 2008 #1 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. Click to expand... 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().
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. Click to expand... 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().
