>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().
You can either scan this view and do replace on each record or do the similar procedure
private pnCount
pnCount = 0
replace Line with NewLine() all
NewLine function:
pnCount=pnCount+1
return pnCount
This is untested.
If it's not broken, fix it until it is.
My Blog