Browse - Browse will not accept inserts after using Erase statement 1

[emaduddeen]

Hi Everyone,

In a procedure there is a browse with an associated update procedure. The browse procedure has a button that calls a procedure so the user can select a customer. Inside this button's accepted embed is an Erase statement to erase the data displayed in the browse as well as everything else on the procedure that contains the browse. There is also a Post (EVENT:Accepted, ?Insert) statement that clicks the browse Insert button.

I noticed if I use the Erase statement before the post statement, the browse will not take in any new rows even though an update procedure is called and the user clicks the Ok button on the update procedure.

Can you tell me what code I am missing to wake up the browse so it will take inserts after it has been cleared with the Erase statement?

Thanks.
Emad

 

[ShankarJ]

Hi Emad,

I really have not tried ERASE on a List Control but since ERASE clears the USE variable, I guess it must be FREEing the Browse Queue. So I guess you need to do a BrowseObject.ResetFromFile to re-read from the Table again. If that does not work, I would suggest you use the SetFilter approach suggested by me in the other thread for the same question.

Regards

 

[emaduddeen]

Hi ShankarJ,

Thanks.

I will try it.

Truly,
Emad

 

[emaduddeen]

Hi ShankarJ,

SalesItemsList.ResetFromFile

worked.

Thanks.

Truly,
Emad