>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.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: 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.
