Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data in one station appear in another station?
Message
From
16/08/1999 12:30:45
 
 
To
09/08/1999 04:27:58
Andrzej Majlich
Vulcan sp. z o. o.
Wroclaw, Poland
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00058304
Message ID:
00254110
Views:
33
>>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.com

To 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
Previous
Reply
Map
View

Click here to load this message in the networking platform