Refresh Form

erugalatha

Hi,

I've got a flowfield showing on a Sales Order form but when I change something in the flowfield (OnDrillDown) then tab off the control the value in the control does not update immediately. It only updates if I close the sales order form and re-open it.

How can I get the flowfield control to refresh immediately?

Thanks in advance.

kriki

Put some code on the dropdown so you control which records to show. And when you return do a Currform.UPDATE(FALSE);

erugalatha

hmmm ... any code in the OnDrillDown causes the drill down functionality not to work. So I've defined a variable of type Form that is the form that the drill down would have run.

how can i set filters on this form and then run it?
myform.SETTABLEVIEW(Rec)????

mightykid

i believe this is what you're supposed to do...

yourrecord.setfilter(field,somefilter);
form.runmodal(form::yourform,yourrecord);
currform.update(false);

erugalatha

Thank you.

I ended up doing it this way:


myrecord.SETFILTER(myrecord."Sales Doc. No.","No.");
myrecord.SETFILTER(myrecord."Carton Type",'BoxA');
myform.SETTABLEVIEW(myrecord);
myform.RUN;
CurrForm.UPDATE(false);

kriki

erugalatha wrote:

Thank you.

I ended up doing it this way:


myrecord.SETFILTER(myrecord."Sales Doc. No.","No.");
myrecord.SETFILTER(myrecord."Carton Type",'BoxA');
myform.SETTABLEVIEW(myrecord);
myform.RUN;
CurrForm.UPDATE(false);

One remark:
Try to avoid SETFILTER. SETRANGE is better!

erugalatha

kriki wrote:

One remark:
Try to avoid SETFILTER. SETRANGE is better!

Does SETFILTER do bad things? #-o

kriki

erugalatha wrote:

kriki wrote:

One remark:
Try to avoid SETFILTER. SETRANGE is better!

Does SETFILTER do bad things? #-o

It will work, but SETRANGE can be better for performance. When putting filters on the fields of the index, with SETFILTER it can happen that Navision is not able to use the index for fast searching but only for ordering.

erugalatha

kriki wrote:

It will work, but SETRANGE can be better for performance. When putting filters on the fields of the index, with SETFILTER it can happen that Navision is not able to use the index for fast searching but only for ordering.

That's good to know - thanks again.