>Craig,
>
>>John is right on here. Updating with record sets is easy, but not the best way to do things. To put things in a Fox perspective, think of the difference between remote views and SQL Pass Through. Now you get the idea between updating with a RS or using the Command object.
>
>More control of the details and better scalability under load. Any others?
Those aren't enough?
>
>>For the record, I have read from many sources that you will get much better control and scalability if you don't update from an RS. You need to call a Stored Procedure via the Command object.
>
>I understand the point, but are those people who do the work also saying that there is a reliability problem? Is it just for heavily-loaded systems?
I don't think we can make a blanket statement that it's just for heavily-loaded systems. The design and implementation of the system needs to be looked at, as does the infrastructure. There are also political things to take into consideration. DBAs typically like things to run through an SP.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer