update a browse based on user input

D

davsimm

New Member
I am trying to do something that should be brain dead easy. I have a fill-in field and a browse widget on window I set up in appbuilder. I set the fill-in field to today's date and told the browse to grab records based on the value in the fill-in field. this works great for the initial form load.

However, when I try to change the value (in this case a different date), I can't figure out how to make the browse update with the new records. I could do this with good ole hand coding in procedure editor, but can't find anything on how to do this in app builder.

Thanks!
 
When you drop a browse onto a container using AB, you get a query defined automatically with the same name as the browse. So, the easiest way of refreshing the browse is to re-open the query using the new date criteria.

So, after some user event ("refresh" button, leave of the date field, "return" of the date field etc), you could something like:

Code: 
OPEN QUERY {&BROWSE-NAME} FOR EACH myTable NO-LOCK WHERE myTable.myDate >= DATE(fiScreenDate:SCREEN-VALUE).

By re-opening the associated query, the browse refreshes to show the results.
 
saratht said:
use browser refresh() function after changing value of that row of browser.
Click to expand...

I don't think the poster is updating any records in the browse. I think they are changing the query criteria based on the fill-in screen-value, so they need to re-open the query. If that's the case, calling a refresh() won't help here.
 
You must log in or register to reply here.
Back
Top