🚀 go-pugleaf

Hey Dale,

I was looking at your post and I don't totally understand exactly what
you're trying to accomplish in your code.
From what I gather this code belongs with some COM/Interface stuff that
you're implementing...

If your are not returning a dataset in your SQL statement (ex: select
emp_name from employees)...
then don't use the Open() method... use the Execute() method for ADOCommands
and ExecProc() method for stored procedures.

Here is my suggestion which is a snipped from a class:
class TTransactionExecutorOps : public TGenericOperation
{
protected:
  // protected data members
  TGenOperationStatusCode _ExecutionResult;
  TOleExceptionAutoPtr    _TheCapturedOleException;
  TADOConnectionPtr       _TheADOConnection;
  TADOStoredProcPtr       _TheADOStoredProc;

  // protected methods
  void GrabTheOleException( EOleExceptionRef TheOleExceptionToCaptureRef )

public:
  // public methods
  explicit TTransactionExecutorOps(TADOConnection*
TheConnection,TADOStoredProc* TheStoredProc)
  virtual ~TTransactionExecutorOps() { ; }
//--------------------------------------------------------------------------
-------------------------------------------
//---------[the meat and potatoes of the
suggestion ]--------------------------------------------------------------
//--------------------------------------------------------------------------
-------------------------------------------
  virtual void DoOperation()
  {
    // try to execute the transaction
    try
    {
      // begin the transaction
      // execute the ado stored procedure
      // commit the transaction
      _TheADOConnection->BeginTrans();
      _TheADOStoredProc->ExecProc();
      _TheADOConnection->CommitTrans();

      // declare the operation a success
      _ExecutionResult = GOSC_Success;
    }

    // catch ole exception here
    catch( EOleException& AnOleException )
    {
      // store the ole exception
      // roll back the transaction
      GrabTheOleException( AnOleException );
      _TheADOConnection->RollbackTrans();

      // declare the operation a failure
      _ExecutionResult = GOSC_Failure;
    }
  }
//--------------------------------------------------------------------------
-------------------------------------------
//---------[end of the meat and potatoes of the
suggestion ]------------------------------------------------------
//--------------------------------------------------------------------------
-------------------------------------------
  virtual TGenOperationStatusCode GetExecutionResult()
  {
    return _ExecutionResult;
  }
  EOleExceptionRef GetCapturedOleExceptionRef()
  {
    EOleExceptionRef TheExceptionRef = *_TheCapturedOleException;
    return TheExceptionRef;
  }



HTH