Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there a way to Append and Delete from a View?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00036808
Message ID:
00036821
Vues:
41
Sure you can. You can treat a view just as if it were any other table. Just make sure that you have table buffering set. Then you can use Insert - SQL or Append Blank, Scatter/Gather... Just make sure that when you are done with the changes that you call either =tableupdate() or =tablerevert() depending upon your needs.

BTW, when you create the view (if it is a remote view) make sure that you specify a primary key and click on the 'Send SQL Updates' checkbox in the lower left hand corner on the 'Update Criteria' tab. That one will drive you nuts if you miss it.

>The title says it all. Has anyone found a way to create new records or delete records from a view? Is it my correct understanding that one can only "update" existing data in a view?
>
>thanks,
>Steve Despres
Everything we see or seems
Is but a dream within a dream
- Edgar Allen Poe
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform