>>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.
Sorry for the incorrect link. The correct one is
www.computer-consulting.comTo avoid view problems in child, this link recommends to use
a grid not linked to master table.
I call a method rowbufrequery every time to refresh invoice rows
instead of parametrized view + requery()
The problem is that append for .... from in not rushmore
optimizable so I must select into temporary table.
* method: rowBufRequery()
tablerevert( .t., 'ROWBUF' )
dele from ROWBUF
select * ;
from INVDETAILT ;
into cursor TEMPROWBUF ;
where INVNO=INVHEADER.INVNO
sele ROWBUF
appe from (dbf('TEMPROWBUF'))
use in ROWBUF
locate
Andrus