Mark,
You don't have to blank out the view. Just use APPEND BLANK and position the record pointer on the new record for editing.
The TABLEUPDATE() will process the changes in existing and insert any new records.
>This is a real newbie question ...
>
>I've always used child TABLES (this is my first stab at using views instead). Want to use a view for the "many" side of a one-to-many. Table buffer it. Want to wrap the TABLEUPDATE in a transaction (along with the tableupdate for the parent and other related tables) in the FORM save() method.
>
>I will be adding, updating and deleting records in this view. I understand that to add a record in a local view, you must first "blank" out the view. To do this I change the view parameter to zero and requery. I get a new view (with no records). What happens to any updates that may have been made previously in this session (and have not yet been TABLEUPDATED). This is a classic invoice/detail situation, so nothing gets tableupdated until the invoice is done.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao