Javier,
I have a similar situation and I did basically what Dan suggests. I base the form on a temporary view and then I have an enhanced speed button on the form that runs the below code. It’s been working great for me. PROPERTY TABLE view_working_sri_po_custom 'CLOSE' PROPERTY TABLE view_working_sri_po_custom 'OPEN' PROPERTY TABLE view_working_sri_po_custom 'RestoreOrderBy' RETURN That’s my 2 cents worth, Paul Buckley R:BASE X.5 Enterprise Version 10.5.3.20119 From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of javier.valen...@vtgonline.com Sent: January 26, 2021 3:25 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Enhanced Grid Question I have an Enhanced grid in a form and when the form is started the proper multi column sort is specified. We use the filter bar to select specific records and sometimes users click the header to sort the elected record by that field and the original sort criteria is lost. I do have a button that pops up the sort builder but since the original sort includes several columns it is not practical to do it often, only for specific situations. On entry to the form, I can capture the sort order via the command: GETPROPERTY vciKCMOFeaturesBase CURRENTSORT 'vDefaultSort' However, the format of the variable vDefaultSort is such: Council_Di ASC, Seg_class ASC, STREETNAME ASC, Seg_prefix ASC, Seg_Suffix ASC, Street_type ASC, Low_Addres ASC That I cannot use it with the PROPERTY command to re-sort the original sort criteria. I have tried several variations of the Property Sort command : PROPERTY vciKCMOFeaturesBase SortASC 'CouncilDistNo' To specify a multi-column sort but I cannot seem to figure out how to specify more than one column to sort. Next, I discovered this command that seems like it would be the answer: PROPERTY TABLE KCMOFeaturesBase 'RestoreOrderBy' And works well provide a column headers on the grid has not been clicked to sort. When one has been clicked the command above will reset the sort back to the original, but the sort previously selected by clicking on the column is not reset. I am not sure if this is by design or not; however, I would think that resetting back to the original SORT criteria would reset all the sort columns that were not part of the original criteria first. Hopefully this makes sense. Any advice or workaround will be appreciated. Javier, Javier Valencia, PE <mailto:javier.valen...@vtgonline.com> javier.valen...@vtgonline.com O: 913-829-0888 C: 913-915-3137 From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > On Behalf Of Tony Luck Sent: Sunday, January 24, 2021 10:35 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: Re: [RBASE-L] - Question of Group By and Having Clause Project temporary scantable from mainscantable using all Sorry forgot to include the from statement Steve my bad. On Mon, Jan 25, 2021, 1:18 PM Steve Johnson <sjohnson...@sprintmail.com <mailto:sjohnson...@sprintmail.com> > wrote: Is there a means to take the statement below and extract the data from the driving table to either create a temporary table/view and/or drive a report directly? The goal is to have the report provide the detail for only those instances where the SCANID exceeds the count number. An ordinary WHERE clause will display each instance of a unique SCANID in addition to multiple instances of the same SCANID when the report is defined correctly, which I currently have. But the report is long due to single occurrences of SCANID and I am only interested in multiple occurrences of SCANID. Seems like a temporary table/view would be ideal to drive the report. SELECT scanid COUNT(*) FROM scan1 GROUP BY scanid HAVING COUNT(*) > 20 Thank You Steve Johnson -- 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/000c01d6f2c8%24be80a050%243b81e0f0%24%40sprintmail.com <https://groups.google.com/d/msgid/rbase-l/000c01d6f2c8%24be80a050%243b81e0f0%24%40sprintmail.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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDAQCHzkyDd8xG75qWPywCiVnX4woKT6nFXwstU4somGfRQ%40mail.gmail.com <https://groups.google.com/d/msgid/rbase-l/CABnhDAQCHzkyDd8xG75qWPywCiVnX4woKT6nFXwstU4somGfRQ%40mail.gmail.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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAABa4qWuusAlBoskXxE2AV1mChgAAEAAAAKM3Sxx2829CryWarYtxP2kBAAAAAA%3D%3D%40vtgonline.com <https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAABa4qWuusAlBoskXxE2AV1mChgAAEAAAAKM3Sxx2829CryWarYtxP2kBAAAAAA%3D%3D%40vtgonline.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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAJ4mzQXf2gpHhGgkNNfb5kTCgAAAEAAAAOsYNervCOtPlnMEino9J9gBAAAAAA%3D%3D%40buckleyandassoc.com.