Refresh fields

This is my web application. I have a computed field on the form which has a formula

@DbCommand( “ODBC” : “NoCache” ; “hh” ; “pp” ; “pp” ; “select nvl(max(DOC_NO)+1,100001) from abc”)

now when I am opening the new document field is taking the preious value. It is not refreshing. If suppose I saved Doc_no=100008 previously in database and when I again opening the new document it shows 100008 value on the field. But after refreshing manually it executes the formula and show the doc_no=100009.

Subject: Refresh fields

How about running viewrefresh from webqueryopen event?

Subject: RE: Refresh fields

How can viewrefresh run from agent as it is using workspace.viewfresh. and agent does not recognize the uiworkspace. My application is web based. I have embedded a view on the form. So how can I refresh a view.

Subject: RE: Refresh fields

Call notesView.Refresh

Subject: RE: Refresh fields

I have also used the same but nothing happens. what else to do.