A project need to monitor the SQL statement, I rewrote the ado _Connection and _Command class, but only the hooks to the Command. The Set_CommandText, occasionally caught several Connection. Set_ConnectionString set the Connection string, my first reaction is the Connection Open, Connection. The Execute these create execution is not in the main thread, also tried the SetWindowsHookEx process under all the threads, but still can only catch the Command. The Set_CommandText this statement,
In addition, if be caught to program using the Command execute SQL, by the Command. CreateParameter (const Name: WideString; Type_ : DataTypeEnum; Direction: ParameterDirectionEnum; Size: Integer; Value: OleVariant) : _Parameter; To obtain the parameters of the filling, of which the last Value: OleVariant how to get the Value?

Beg ace show just a little ~

CodePudding user response:

Can't directly use the event detector?