I need to set the Line number in my view. This updatable view has a extra field call line. This field is the number of the line according to the order set in the view.

How can I set this line Number in my view? I need this field to be reset when I do Requery().