Global Sort Option for select RDBMS
Author: william-paul.philibert@telus.com (wpphili)
Bonjour, we recently upgraded from version 9.4 to 9.6 but more importantly from Sybase driver U2 to U4. There is a major change in the way the driver handle request to the database. Using the driver U2, there were index suggestion everywhere witch, in a way, took care of the sorting order of the result. Now, with the driver U4, there are no more index suggestion, leaving all the decision to the database with an unwanted/unexpected result that rows fetch from the database are no more sorted and are displayed as is in the different forms. My question, besides going into each and every form to add "order by" clause, is there any way to have a global sort somewhere or anything else that could "easily" fix this behavior? Thanks for your time, support and knowledge. Regards, William P. Philibert