I just sort of bumbled onto it when I was setting up a form and went through the exercise of setting up both a Scrolling Region and a DBGrid trying to figure out which would work best. I clicked on a DBGrid column and noticed something was different in the Scrolling Region....Whoa! Dude! (That's sort of an approximation of what I said). Just to be sure I tried it on a second form, different table (beta test) - the rest is history.
Thanks,
Doug
[email protected] wrote:
Oh Doug, that is VERY clever! I've always just put buttons to re-sort. No way you thought of that yourself ;-o
Karen
By chance, I found that you _can_ sort a scrolling region without basing it on a view by using both a Scrolling region and a DBGrid: Build your scrolling region, locate DBEdits and variables if you want &get it all fluffed up - the SR is your data viewing/editing area. Then create a DBGrid on the same table. Locate the same columns in the grid that you have in the SR - same position, same width. Make the height of the DBGrid just enough to show column headings and locate the DB Grid right above the SR. Click a heading in the DBGrid and the scrolling region sorts. A test table with 365,000 rows sorts instantaneously on PK &indexed columns. Only drawback is you can't move the columns... well, you can in the grid but they don't move in the SR.
(RB 7.6.6.30315, but I suspect it's been capable of this for a while)
Doug
