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) callEventHandlerOrMethodForReordering return result End Function
do the same with executeSQL only without returning someting
This works for sqlite and other db’s.