I'm using the with view metadata clause in views. As a result I can not use order by in the select statement so my recordset will automatically be sorted by the Primary Key.
I did use order by in combination with the 'top' statement, as a result the recordset isn't updatable whilst I would like to keep it updatable.
When showing the recordset in the access client I want it to be sorted to two different fields than the primary. How can I easily achieve this while keeping the recordset updatable?
I did use order by in combination with the 'top' statement, as a result the recordset isn't updatable whilst I would like to keep it updatable.
When showing the recordset in the access client I want it to be sorted to two different fields than the primary. How can I easily achieve this while keeping the recordset updatable?
