Thank you Jim, The sort dialog works great; however, the footer calculations don’t seem to be available in my version which is a couple of years old. On a related issue, id there a Property/GetProperty command to retrieve the current search criteria generated by user criteria in the Row Select band? Thanks again, your help got me over one of the many issues; luckily, the programming skills seem to be coming back. J Best regards, Javier Valencia, PE 14315 S. Twilight Ln. Olathe, KS 66062 Cell: 913-915-3137 From: 'Jim Belisle' via RBASE-L [mailto:[email protected]] Sent: Wednesday, November 18, 2020 9:13 AM To: [email protected] Subject: RE: [RBASE-L] - Questions on Enhanced grids Javier, About the footer for the dbgrid. In the enhanced options, use the show footer and navigation events on calculation.
Then in the column properties, choose which column you want to have your calculation. On this one, I want a sum based upon the filter (or no filter). James Belisle Making Information Systems People Friendly Since 1990 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] 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/CY4PR0201MB339457D894FCBD5A722A06CCA0E10%40CY4PR0201MB3394.namprd02.prod.outlook.com <https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB339457D894FCBD5A722A06CCA0E10%40CY4PR0201MB3394.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer> . -- 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/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAKGOWAbvwxdFrU3H7mSug20BAAAAAA%3D%3D%40vtgonline.com.
