>I am trying to create a remote view to my sql server 6.5 database and look at my products table. I would like to be able to make updates to the table right through fox pro by looking at it in a table and make a change to the data move to the next record and have the update sent through back to my SQL database. Ist here a way to do this?
If you choose the "Send SQL Updates" option when defining the remote view AND your table has some type of primary key, the view will send updates back to the server as you make them.
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.