You can base the form on a temp view. Then you can close the view and reopen it to refresh it. There is an example in the RSAT to see how it works: this is some code: PROPERTY TABLE temptableviewname CLOSE
DROP VIEW temptableviewname CREATE TEMPORARY VIEW `temptableviewname` + AS SELECT columns from tablename where clause order by clause property temptableviewname open Dan _____ From: [email protected] [mailto:[email protected]] On Behalf Of mike epstein sony viao office Sent: Wednesday, April 01, 2009 4:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: sorting a scrolling region ,a senior moment That is correct the 2 columns are changed on edit and I am trying to re-sort the data that is currently visible in the dbgrid based on the changes. From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, April 01, 2009 5:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: sorting a scrolling region ,a senior moment So the two columns you want to resort are not the original sort?? Dan _____ From: [email protected] [mailto:[email protected]] On Behalf Of mike epstein sony viao office Sent: Wednesday, April 01, 2009 3:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: sorting a scrolling region ,a senior moment Good Evening The db grid that I am using has a data based on specific date vehicle and delivery priority . the columns that change on edit are vehicle number and priority for the specific date . I would like to have a button that would resort the data listed in the form to be resorted by the 2 columns . a' restoreorderby' property command does not seem to address specific rows of the table in the form? Mike From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, April 01, 2009 9:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: sorting a scrolling region ,a senior moment This one is for dbgrid. Restores the default data set sort order for a DB Grid. Syntax: PROPERTY TABLE <FORMTABLENAME> 'RestoreOrderBy' _____ From: [email protected] [mailto:[email protected]] On Behalf Of mike epstein sony viao office Sent: Wednesday, April 01, 2009 7:32 AM To: RBASE-L Mailing List Subject: [RBASE-L] - sorting a scrolling region ,a senior moment Good Morning I haven't received any response to the post I made earlier this morning which is good since the object is a dbgrid not a scrolling region so, I have a form with a dbgrid that I use to edit data. After the edit, but before the form is closed, I would like to use a button to refresh the values in the dbgrid by re ordering the data In the dbgrid using 2 columns. Mike
