I have a form with numerous field and an embedded browse. When opening the form, I have set the order expression to the <date> field of the table and it shows the most recent entry first in the embedded browse (3/20,3/19,3/18 etc...) If a user presses a button "new", the last line of the browse is highlighted, the user enters there data in the form presses save, the browse shows the new data but it is at the bottom of the browse, regardless of date. I then have to double click the date column of the browse to re-sort by date. What I would like to see happen, is when the user presses the save button, the browse is automatically sorted and displayed as it was originally when the form was first opened, by date (3/20,3/19....)
-
-
Re: Refresh Embedded Browse
From what you have described, you are building this form on a set where the browse is a child table.
If so, then use the definition of the set to set the order of the browse records.
If the browse is based on the parent table, then build an index for the order desired and set the index in the oninit event.Al Buchholz
Bookwood Systems, LTD
Weekly QReportBuilder Webinars Thursday 1 pm CST
Occam's Razor - KISS
Normalize till it hurts - De-normalize till it works.
Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.When we triage a problem it is much easier to read sample systems than to read a mind.
"Make it as simple as possible, but not simpler."
Albert Einstein
http://www.iadn.com/images/media/iadn_member.png -
Re: Refresh Embedded Browse
Al, thanks for the quick reply. My browse is based on the parent table. I have no set involved. As a newbie, can you give my some help on indexing. Will this solve the issue of my previous post?Comment
-
Re: Refresh Embedded Browse
Al, I created an index (dateorder) in the forms table, and placed the following code in the onInit event: parentform.index_set("DateOrder"), and I see no difference on how the browse records are displayed AFTER saving a new record in the form. I have the form when opened, displaying the records in descending date order.
DATE CUSTOMER NAME CITY STATE
3/20 George Bush Houston TX
3/19 John Doe New York NY
3/15 Ann Smith Miami FL
Currently: if the user enters a NEW record dated 3/17, the new record is displayed at the end of the browse, until the "DATE" column is double click, at which time, the DATE order is ascending or descending based on the number of times you click DATE...
What I would like to accomplish: user enters "NEW" record, when the save button on the form is pressed, the record is automatically placed in descending date order without having to double click "DATE" column
DATE CUSTOMER NAME CITY STATE
3/20 George Bush Houston TX
3/19 John Doe New York NY
3/17 Albert Einstein Orlando FL
3/15 Ann Smith Miami FLComment
-
Re: Refresh Embedded Browse
Jon, here's an example that uses the OnSave event of the browse object to refresh the display of the form at parent level. Seems to meet your requirements. Hope it helps.
--tomComment
-
Re: Refresh Embedded Browse
Tom, I appreciate your example and simple solution. How do I get the same result if a user presses the cancel button either in the toolbar or a custom 'cancel' button on the form.Comment
-
Re: Refresh Embedded Browse
Tom,
I could not get your example to resort the records with the OnSave so that the browse records end up in invert(tx_date) order with the first record showing the newly added record.
Jon,
In the attached example starting from Tom's, I added a button that uses a quick sort after the save step to resort the browse. See if that works for you.
I know that entering records through a browse seems easy and available, but I never do it. I always use an xdialog box to collect the information and write that information directly to the table through variables, and then engage any sorts and refreshes after that. It may not be your "cup of tea" but i put an example on the "new" button if you might like it.Mike W
__________________________
"I rebel in at least small things to express to the world that I have not completely surrendered"Comment
-
Re: Refresh Embedded Browse
Mike, there's an ordering statement in the set design. My testing was done by entering a variety of new records and the browse correctly places them in proper sort sequence. I don't recall testing the upper or lower bounds. My tests were dates that fell in between existing records.Comment
-
Re: Refresh Embedded Browse
Tom,
Isn't the set ordering/filtering analogous to having a base filter / order on a form?? I rarely have seen users do this and have yet to see a need for having such a filter myself, but it sure seems to be a very limiting way of filtering / ordering. I guess my main question is whether such a filter / order behaves like the base filter of a form....and what is the order of precedence ? Can a simple query override this set based filter (would not think so)?Comment
-
Re: Refresh Embedded Browse
Mike & Tom, thanks for you input(s). I have attached a very simple example of the database I'm making. What I want to accomplish at this point is: I would like if the user presses the 'new' button on the form and for one reason or another decides to cancel what they are doing, when they press the 'cancel' button, the browse goes back to the top of the browse and shows the most recent date first (3/1, 2/28...etc). Right know if the user presses the 'cancel' button in the middle of inputting a new record, the bottom of the browse data is shown, the the user has to double click the date column of the browse to re-sort the browse in a ascending or a descending order. Thank you in advance...Comment
-
Re: Refresh Embedded Browse
....Right know if the user presses the 'cancel' button in the middle of inputting a new record, the bottom of the browse data is shown, the the user has to double click the date column of the browse to re-sort the browse in a ascending or a descending order. Thank you in advance...
Not in my hands! The browse remains sorted throughout the entry process and the pressing of the Cancel button simply cancels the entry process and the Browse continues to be sorted appropriately.Mike W
__________________________
"I rebel in at least small things to express to the world that I have not completely surrendered"Comment
-
Re: Refresh Embedded Browse
Mike, I may have misspoken, my apologizes... I agree when the user presses the 'cancel' button during the entry process, the browse remains sorted appropriately. What I want the browse to display when the 'cancel' button is pressed is the top of the browse records NOT bottom of the browse records based on descending date.
FOR EXAMPLE: If the user has 100 records in the browse and wants to add another (101), then during entry process presses the 'cancel' button, I would simply like the browse to refresh and display the 1st record, 2nd record, 3rd record etc (again based on descending dates) just like it is displayed when the form is first opened. Right know to accomplish this, the user has to double click the 'date' column and has the choice of viewing the records either ascending or descending (based of the date).Comment
-
Re: Refresh Embedded Browse
Jon,
Rather that have the "Refresh Display" in the action scripting on the Cancel button, you can just issue a fetch first record for the embedded browse. This will select the first record in the browse in the current sort order when the Cancel button is pressed.
ErnieComment
-
Re: Refresh Embedded Browse
Ernie, thanks for the input. What the possibly of you adding the fetch first record to the cancel button in example3 database I previously provided. Sorry... just learning xbasic... Thank you in advance.. JonComment
-
Re: Refresh Embedded Browse
Jon,
Here is the Action Scripting for the Cancel button. This action script is under Record Navigation. You can then select Parent Record or Embedded Browse. I just selected embedded browse, although I'm really not sure if it makes any difference.
ErnieComment
Comment