Thanks Dan, That is the approach I have used in the past and I was hoping I would no longer need it in view of all the new PROPERTY commands that do essentially the same thing, well…almost???
Is there a way to use the PROPERTY command to sort by more than one column? A lot of new features to assimilate when you get a version that’s 3 years newer. 😊 Javier, Javier Valencia, PE <mailto:[email protected]> [email protected] O: 913-829-0888 C: 913-915-3137 From: [email protected] <[email protected]> On Behalf Of Dan Goldberg Sent: Tuesday, January 26, 2021 3:15 PM To: [email protected] Subject: RE: [RBASE-L] - Enhanced Grid Question You can base the form on a view instead of a table. then in your button eep for default PROPERTY TABLE formviewname 'close' DROP VIEW formviewname NOCHECK CREATE TEMP VIEW formviewname + AS SELECT columnnames FROM tablename + ORDER BY defaultorderbyseq asc PROPERTY TABLE formviewname 'open' Dan Goldberg From: [email protected] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > On Behalf Of [email protected] <mailto:[email protected]> Sent: Tuesday, January 26, 2021 12:25 PM To: [email protected] <mailto:[email protected]> 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:[email protected]> [email protected] O: 913-829-0888 C: 913-915-3137 From: [email protected] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > On Behalf Of Tony Luck Sent: Sunday, January 24, 2021 10:35 PM To: [email protected] <mailto:[email protected]> 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 <[email protected] <mailto:[email protected]> > 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 [email protected] <mailto:[email protected]> . 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 [email protected] <mailto:[email protected]> . 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 [email protected] <mailto:[email protected]> . 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 [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E7C544B%40EXCHANGE10 <https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E7C544B%40EXCHANGE10?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!AAAAAAAAAAAYAAAAAAAAABa4qWuusAlBoskXxE2AV1mChgAAEAAAAAaIB3tlMVxDhRhCfkpPdhwBAAAAAA%3D%3D%40vtgonline.com.
