Anyone reordered a table and the array that populates it?

I can grok the example app that does table reordering. Any suggestions on how to communicate back to the app that this has occurred so that the underlying data in the array can be reordered?

subclass the db selectSQL and executeSQL:

Something like so:

Function selectSQL(sql As string, ParamArray params As variant)
Var result As Rowset = selectSQL(sql, params)
return result
End Function

do the same with executeSQL only without returning someting

This works for sqlite and other db’s.