Re: Detecting Commits

Hello Steve,

I have since solved the problem by other means. I was trying to deterimine that time that rows got commited versus the time that the insert statement was processed.

Thanks,

Matthew
Steve Haynes wrote in message ...
>In article <6vdqm9$jn7$1_at_uuneo.neosoft.com>, Matthew MacFarland
><matthew_macfarland_at_dril-quip.com> writes
>>Does anybody know a way to detect when users transactions get commited? I
>>need to build an audit table with a USER and DATE record for each commit
>>that takes place in order to debug an application.
>>
>This is a very strange thing to want to do.
>I suspect you would have to write a commit_it() procedure
>and insert into my_audit_record(user,date) yourself.
>Obviously replacing existing commits with a call to your
>new commit_it() procedure.
>Strange, OK I give in, why do you want to do this?
>Steve
>--
>Please remove nospam from my address to Reply.
Received on Wed Oct 07 1998 - 16:18:30 CDT