How does ADO 2 update a SQL stored procedure recordset?

Generally when I want to use ADO 2 to update a recordset based on a MSSQL
stored procedure I will handle the OnWillChangeRecord event, and explicitly
call a second stored procedure to perform the update.

If I don't handle the OnWillChangeRecord event (and permissions are set
properly, etc.) ADO will "magically" update the SQL tables for me. How does
this actually work?

Suppose a stored procedure joins two or more tables: how does ADO figure
out which tables are to be updated, when all it would seem ADO has to work
with is the resultset returned by the stored procedure?

(To clarify, I know that it DOES work, I would just like to understand HOW.)

A related question: other than the obvious differences in permission
requirements and ability to perform additional tasks in the update stored
procedure, are there differences between these two approaches? Is one
preferred (in terms of security, performance, stability, etc.)?

Thanks in advance for any light you can shed.

David Rueter
drueter@xxxxxxxxxx



.

Relevant Pages

  • Re: SQL Server stored prcedures with output parameters
    ... the stored procedure below appears to consistently ... > moment) how ADO handles that. ... Parameter 1 had direction input ... Appending parameter value http://www.holdenweb.com/ ...
    (comp.lang.python)
  • Re: Stored Procedure is running slow!
    ... > I run stored procedure from QA, it takes some 15 seconds to execute. ... > seconds when called from MS Fox Pro, via ADO. ... Try this in Query Analyzer: ... By default Query Analyzer runs with ARITHABORT ON, ...
    (microsoft.public.sqlserver.programming)
  • Re: Very bad response time from stored procedure call via ADO
    ... We have a stored procedure that returns some statistical information ... SQL Server is version 2000 ... When run in SQL Query Analyser the typical duration is 400ms. ... When run from the VB6 application via ADO the duration increases to ...
    (microsoft.public.data.ado)
  • Re: Stored procedure functionality and visibility questions
    ... I have the impression that most of the time it's best to use DAO or ADO ... >>>but I also keep reading about additional stored procedure support that was ... I've looked into using a VBA function or procedure to perform the task ... >> application automate Access. ...
    (microsoft.public.access.modulesdaovba)
  • Re: How can a recordset returned by a sproc be updated?
    ... With the resultset metadata is returned to the client that allows ADO and ... SQL Server MVP ... > ADO. ... I tried making a view and having the stored procedure select ...
    (microsoft.public.sqlserver.programming)