SORTEDCOL and problems with empty rows... sometimes. (OpenInsight 32-Bit)
At 20 DEC 2006 02:15:00PM Jim Peters wrote:
I've used SORTEDCOL on EditTables here and there and found it worked well within its limitations.
However, while trying to add rudimentary column sorting to some fairly simple databound EditTables via a promoted CLICK event, I started having problems with it wanting to sort the trailing blank rows along with the data.
The EditTables having the problems are just simple ones with columns bound to literal fields, and maybe 4 or 5 columns. I looked in the records, and they do not contain any extra trailing Vm's. Other EditTables work fine and sort only the data.
Has anybody else encountered this, and is there a simple fix? I know there are other ways to accomplish this, but I would like to figure out why this is happening.
Thanks,
Jim
At 26 DEC 2006 09:37AM W Shepard wrote:
I think you want to clear the excess empty lines with ETMETHOD before sorting.
Wayne
At 28 DEC 2006 02:53PM Jim Peters wrote:
My understanding was that SORTEDCOL is supposed to work without having to do a TRIM on the edittable and in the process making the table look all ugly. Most of the time it does work just fine.
At other times though, an edittable just seems to resist all efforts to make it sort without moving all the empty rows to the top in the process. (I know there are some brute force methods to duplicate the functionality posted here somewhere.)
I was hoping somebody could shed some light on WHY this is happening. Is SORTEDCOL maybe just broken, as Sean suggested on the recent ETMethod thread? I am trying this on 7.2, not 7.2.2 by the way.