>Hello All;
>here is the situation...
> I have a remote View of a SQL Server 7.0 Table in my Database, which has been checked to 'Send SQL Updates'. In my Code, I replace a value from .F. to .T. and update the View... however I get the error 'Update Conflict' and I must do a Tablerevert() to get out of the error.
>
>The view is created as "Select Field1, ... from PoDetails where ItemNumber = ?Thisformset.ItemNo"
>
>Any Suggestions?
Do you have a primary key field (or fields) selected in the remote view? VFP needs to know how to uniquely identify the record in order to map changes back.
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.