Store Procedures

Hvordan ser din Accessor klasse ud?

class CspBrugereAccessor
{
public:
    //LONG m_RETURNVALUE;
    LONG m_Prof;
    LONG m_Type;
    TCHAR m_Navn[51];
    TCHAR m_colBrugernavn[5];
    TCHAR m_colFornavn[51];
    TCHAR m_colEfternavn[51];

BEGIN_PARAM_MAP(CspBrugereAccessor)
    SET_PARAM_TYPE(DBPARAMIO_OUTPUT)
    //COLUMN_ENTRY(1, m_RETURNVALUE)
    SET_PARAM_TYPE(DBPARAMIO_INPUT)
    COLUMN_ENTRY(2, m_Prof)
    COLUMN_ENTRY(3, m_Type)
    COLUMN_ENTRY(4, m_Navn)
END_PARAM_MAP()

BEGIN_COLUMN_MAP(CspBrugereAccessor)
    COLUMN_ENTRY(1, m_colBrugernavn)
    COLUMN_ENTRY(2, m_colFornavn)
    COLUMN_ENTRY(3, m_colEfternavn)
END_COLUMN_MAP()

DEFINE_COMMAND(CspBrugereAccessor, _T("{ ? = CALL dbo.sp_Brugere;1 (?,?,?) }"))

    // You may wish to call this function if you are inserting a record and wish to
    // initialize all the fields, if you are not going to explicitly set all of them.
    void ClearRecord()
    {
        memset(this, 0, sizeof(*this));
    }
};

?