CRecordset & Parametrized filter

[Oscar Paytuvi]

Hi all,

Here it is an example of what I want:

//{{AFX_FIELD_MAP(CUbica1Set)

pFX->SetFieldType(CFieldExchange::outputColumn);

RFX_Text(pFX, _T("[NUMUBICACION]"), m_NUMUBICACION);

RFX_Text(pFX, _T("[FILA]"), m_FILA);

RFX_Text(pFX, _T("[COLUMNA]"), m_COLUMNA);

RFX_Byte(pFX, _T("[ESTADOENT]"), m_ESTADOENT);

RFX_Byte(pFX, _T("[ESTADOSAL]"), m_ESTADOSAL);

RFX_Text(pFX, _T("[REFERENCIA]"), m_REFERENCIA);

RFX_Text(pFX, _T("[NUMPALETS]"), m_NUMPALETS);

RFX_Date(pFX, _T("[FECHAHORAULTIMAENTRADA]"), m_FECHAHORAULTIMAENTRADA);

RFX_Text(pFX, _T("[DISTENTRADAMANUAL]"), m_DISTENTRADAMANUAL);

//}}AFX_FIELD_MAP

pFX->SetFieldType(CFieldExchange::inputParam);

RFX_Byte(pFX, "[ESTADO]", m_EstadoParam);

RFX_Text(pFX, "[NUMPALETS]", m_NumPaletsParam);

RFX_Text(pFX, "[REFERENCIA]", m_ReferenciaParam);

then m_nParam=m_nParam+3 and:

m_strFilter="ESTADO=? AND NUMPALETS=? AND REFERENCIA=?";

This is the situation and then I use that in the way:

m_estadoParam='1'; //I only one to requery for this //parameter and I want to ignore the other two

Requery();

What I want is to be able to make the select of with one param, or two or three but maintaining the m_strFilter in the

same way...


Help me please...