Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a way to Append and Delete from a View?
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00036808
Message ID:
00036821
Views:
44
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
Previous
Reply
Map
View

Click here to load this message in the networking platform