Browse in form refresh

[ralonso2001]

Hi, I have some problems with Browse in form (parent child update) with the filter (using SQL() for filter expresion).
If I use PAGE loaded, when I add the second child record "NO RECORDS" are displayed, if I refresh the browse,  records reapear.
With the same configuration I check FILE loaded for the browse and the refreshing works fine.

First,question: Is there a problem using FILE instead of PAGE loaded browses?

Second question: Any ideas why this behavior?

Thank you!!!

[kevin plummer]

sounds like something is breaking the filter after it is loaded and maybe why it works as page loaded on first page and on file load.

Performance wise it depends on size of file like in a normal clarion app.

[Bruce]

Hi Rodrigo,

It's a good idea to post the contents of the filter setting here when asking filter questions. As you note it's likely a problem with your filter but not being able to see the filter makes it hard to comment.

There's also a template option to send the filter to debugview, so pasting the output from that here is also useful as you can see what your template setting resolves to.

PS - 9 times out of 10 the use of SQLFilter is unnecessary - but again commenting on that is hard without seeing the filter.

cheers
Bruce