If I knew I would never choose VFP to make my apps.
>I think that when adding rows, their record numbers are -1, -2 etc.
>(same in all instances) and this confuses fox.
This is not my case - I use row buffering not table. So my records have a proper numbers.
>Finally, I was unable to use this way of editting.
>Instead I create a local cursor and edit invoice rows in this
>cursor. Save command adds rows from locak cursor to network table
>and makes tablerevert() to local cursor.
I've decided to use the technique. But I've noticed problems with REQUERY(). The SQL defining the view gave a good set of recs but the view didn't. The remedy was to change position in a parent table (parametrized view) just after saving invoice rows and before REQUERY.
>This is a good
>invoice editing tip described in
www.computer-consultint.com vfp tips.
Thanks for the link - maybe there is an answer.
_________________
*|| Andrzej [NJ].