QBF - Sorting results by a column (OpenInsight 32-bit Specific)
At 13 DEC 2003 01:48:22PM James Jenka wrote:
I have added QBF buttons on forms in an application I am developing. I would like to add some functionality to the EXECUTE button. Currently, EXECUTE returns my rows in a random order as they are stored in the linear hash table. I would like to have the results returned in alphabetic order based on my column 1 which is always named NAME or DESCRIPTION. I have a QuickEvent for Click on the button sending a message to the Control/Window variable @Window with a message of QBFRUN. I have attempted many variations of code in the event handler. My form is always named the same as the table. Basically, all I want to do there is something like SELECT @WINDOW BY NAME. I understand that I must end with a return 1 instead of return 0. I have changed the code that I thought would accomplish this over and over again but none have made it through the debugger. I have been unable to obtain assistance through the normal channels and am ready to go back to ARev where I have libraries of routines and can almost design applications in my sleep. HELP! Someone must be doing something similar. What am I missing? THANK YOU!
At 13 DEC 2003 02:16PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Are you willing to us the standard AREV style syntax of BY1 BY2 in the fields you want to sort by? Whilst we can't find this in the online Docs it was added by Mike and his team.
World Leaders in all things RevSoft
At 13 DEC 2003 02:33PM James Jenka wrote:
I am willing to change the column name to DESCRIPTION from NAME for each form as needed.
At 15 DEC 2003 11:03AM James Jenka wrote:
I had a brainstorm - Maybe adding a btree index on the column would cause it to sort automatically with QBF. Sure enough - it works. It just proves that sometimes we ignore the most obvious solutions.