OnWillChangeRecord not firing

From: David Rueter (nospam_drueter_at_assyst.com)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 12:39:50 -0800

I am trying to implement updating of a dataset returned by a TADOStoredProc
along the lines suggested in:

MS Knowledge Base: Q191793 "HOWTO Intercept UpdateBatch and Call a Stored
Procedure"

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q191/7/93.asp&NoWebContent=1

However, I can't seem to get the TADOStoredProc to fire the
OnWillChangeRecord event.

I open the stored procedure, kick the dataset into edit mode, make
modifcations through data-aware controls, then call Post.

No exception is raised, but OnWillChangeRecord never fires.

On the TADOStoredProc I am using the following property settings:

    CursorLocation := clUseClient
    CursorType := clStatic // tried ctKeyset also
    LockType := ltBatchOptimistic

The connection is to an MSSQL 2000 database via MDAC 2.8. I'm running
Delphi 6 Enterprise Update 2.

Any ideas on how to get OnWillChangeRecord to fire, and/or another event to
handle when TADOStoredProc.Post is called?

David Rueter
drueter@assyst.com