Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views
Message
From
17/04/2001 12:28:28
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Views
Miscellaneous
Thread ID:
00496168
Message ID:
00496183
Views:
10
>I have the folowing situation. I am using a view which is not updatable. It is not updatable since we have found that when a view get to be rather large say 500 records or so it causes problems on our network. So instead I am using the view to obtain the records I need and then using the view I seek the record in the original table and update record by record. However prior to saving I need to print some labels based on the view but some of the information in the view has to be updated. Do you think it is safe to update the field in view even when it is not updatable or am I better off creating a temporary cursor and putting the info that I need for printing in it.

If the view is not updatable, there isn't a way the changes will get back to the source table unless you force the issue (by making it updatable). So yes, it should be safe to do that.
Dan LeClair
www.cyberwombat.com
SET RANT ON - The Wombat Blog

Life isn’t a morality contest and purity makes a poor shield. - J. Peter Mulhern
Disclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
Previous
Reply
Map
View

Click here to load this message in the networking platform