HRESULT Execute(
		_Outptr_opt_result_maybenull_ IUnknown** ppInterface,
		_In_opt_ DBPARAMS* pParams,
		_Inout_updates_opt_(ulPropSets) DBPROPSET *pPropSet,
		_Out_opt_ DBROWCOUNT* pRowsAffected,
		_In_ ULONG ulPropSets = 0) throw()
	{
		HRESULT hr;
		if (ppInterface)
			*ppInterface = NULL;

		// Specify the properties if we have some
		if (pPropSet)
		{
			// For backward compatibility, if the default parameter is not
			// specified, then set it to one if a property set exists
			if (ulPropSets == 0)
				ulPropSets = 1;

			CComPtr<ICommandProperties> spCommandProperties;
			hr = m_spCommand->QueryInterface(&spCommandProperties);
			if (FAILED(hr))
				return hr;

			hr = spCommandProperties->SetProperties(ulPropSets, pPropSet);
			if (FAILED(hr))
				return hr;
		}

		// If the user want the rows affected then return it back, otherwise
		// just point to our local variable here.
		DBROWCOUNT nAffected, *pAffected;
		if (pRowsAffected)
			pAffected = pRowsAffected;
		else
			pAffected = &nAffected;

		if (UseMultipleResults())
		{
			hr = m_spCommand->Execute(NULL, __uuidof(IMultipleResults), pParams,
				pAffected, (IUnknown**)GetMultiplePtrAddress());

			if (SUCCEEDED(hr))
			{
				hr = GetNextResult(pAffected, false);
			}
			else
				// If we can't get IMultipleResults then just try to get IRowset
				hr = m_spCommand->Execute(NULL, GetIID(), pParams, pAffected,
					ppInterface);
		}
		else
		{
//--------------------------------------------------<-------------------------------------------------------!!!
			hr = m_spCommand->Execute(NULL, GetIID(), pParams, pAffected,
				ppInterface);
		}
		if (SUCCEEDED(hr))
			SetupOptionalRowsetInterfaces();

		return hr;
	}
};

else
		{
//--------------------------------------------------<-------------------------------------------------------!!!
			hr = m_spCommand->Execute(NULL, GetIID(), pParams, pAffected,
				ppInterface);
		}

HRESULT SetLongData(TheBIND *pBind,long lData,long *plOffset)
		{
			HRESULT hr = S_OK;
			DBSTATUS dbStatus = DBSTATUS_S_OK;
			pBind->Clear();

			m_Datas.AddBYTES((BYTE *)(&lData),sizeof(lData));
			m_Datas.AddBYTES((BYTE*)(&dbStatus),sizeof(dbStatus));
			pBind->dbColumnSize = sizeof(lData);

			pBind->dbType = DBTYPE_I4; // <------------------??
			pBind->lDataOffset = *plOffset;
			(*plOffset)+=sizeof(lData);
			pBind->lStatusOffset = *plOffset;
			(*plOffset)+=sizeof(dbStatus);
			return S_OK;
		}

class CMyByteArray : public CAtlArray<BYTE> 
{
public:
	size_t AddBYTES(BYTE *pData,size_t size)
	{
		if(pData==NULL || size==0)
			return GetCount();
		size_t Old = GetCount();
		SetCount(Old+size);
		memcpy(GetData()+Old,pData,size);
		return GetCount();
	}
};

HRESULT SetLongData(TheBIND *pBind,long lData,long *plOffset)
		{
			HRESULT hr = S_OK;
			DBSTATUS dbStatus = DBSTATUS_S_OK;
			pBind->Clear();

			m_Datas.AddBYTES((BYTE *)(&lData),sizeof(lData));
			m_Datas.AddBYTES((BYTE*)(&dbStatus),sizeof(dbStatus));
			pBind->dbColumnSize = sizeof(lData);

			pBind->dbType = DBTYPE_I4; // <------------------??
			pBind->lDataOffset = *plOffset;
			(*plOffset)+=sizeof(lData);
			pBind->lStatusOffset = *plOffset;
			(*plOffset)+=sizeof(dbStatus);
			return S_OK;
		}