>>Nothing to do with SQL. If you want to iterate the table in the DataView order you need to use the DataView NOT the table
>
>Yes, I understand. I still do not understand why this is working as is when I create the dataset manually.

Shouldn't this:

   ' Sort the dataset into the primary key
                oData.oDataView.Sort = "AI"
 
                ' For each record
                For lnCounter = 0 To oData.nCount - 1
                    loRow = oData.oRows(lnCounter)
                Next

be:

oData.oDataView.Sort = "AI"
 
                ' For each record
                For lnCounter = 0 To oData.oDataView.Count - 1
                    loRow = oData.oDataView.Item(lnCounter)
                Next

(Haven't checked the exact syntax). Once again: you are looping through the table in the first case - the DataView may as well not exist.