I use a simple PROPERTY command to bring up a sort box. Then you can choose any column or combination of columns.
PROPERTY Comp_OPFgrid SHOWSORTDIALOG 'TRUE' RETURN [cid:[email protected]] James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] <[email protected]> On Behalf Of [email protected] Sent: Wednesday, November 18, 2020 2:02 AM To: [email protected] Subject: [RBASE-L] - Questions on Enhanced grids I am working with an enhanced grid in a form and I have a few questions since it has been a while since I have worked with them. I specify the sort (8 columns) in the EDIT USING statement but I would like to option of sorting on the fly by clicking on the column headers. I can do this but so far it allows me to sort by only one column at the time. When I click on one header all previous sorts are lost and it sorts only by the last header clicked. I am pretty sure there is a way to do it but I cannot seem to remember how to do it. The alternative would be to use a PROPERTY command and I have one that works: PROPERTY vciKCMOFeaturesBase SortASC 'Seg_class' But as far as I can tell it can sort one only column at the time. I have tried entering several PROPERTY sort commands, each with a separate column but the last command will override all the previous commands and I end up sorting only by the last command; no different than clicking headers. My workaround has been to disable clicking on header to maintain the original sort; I would prefer to have the capability of sorting and maybe have a button with the right commands that restores the original sort. I would also like to know if there is a way to add a footer to the grid that adds, or perform other operation such as average or max, for the values in specific columns. I can recalculate the values separately but having one option that does it automatically would be nice. I seem to remember reading something about it; perhaps versions more recent than mine have the capability. Last, if anyone has a quick write up or any information on drag and drop between two grids, I would be very much appreciate it if you could share the information or your experience. I have not done much programming in the last couple of years and, with my failing memory, what used to be easy apparently is not so easy anymore. I was happily settling into my semi-retirement but a large project that will require some data processing came along and now I am back in the rat race. Any help you can provide would be greatly appreciated. Javier, Javier Valencia, PE [email protected]<mailto:[email protected]> O: 913-829-0888 C: 913-915-3137 ________________________________ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394C3A5EFFE2171C67FA222A0E10%40CY4PR0201MB3394.namprd02.prod.outlook.com.
