I haven't been able to find a way to do this, outside of just having a dropdown field with the field names and having the user select which field they want to sort by before the connection behavior is executed and then have to execute the connection behavior to change the order each time.
It seems like Perfectforms really needs a control available for us to use in the forms like the connect and search results table.
It is better to handle the 'sort' from the database side (probably what you have done I think from what you say) but may also be able to do this with the Set Table Row behaviour where you could compare the text in 2 rows and then 'move' a row up or down depending on the result? Would see this as quite complicated to do though
Ehh, that sounds like a lot of extra work. I think i'll wait until theres a new dataset control with sorting capabilities...nudge nudge
