Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Add Record to Table-Buffered View
Message
 
 
À
18/07/2000 11:51:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00393861
Message ID:
00393868
Vues:
18
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.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform