|
-
April 1st, 1999, 10:35 AM
#1
CRecordset & Parametrized filter
Hi all,
Here it is an example of what I want:
//{{AFX_FIELD_MAP(CUbica1Set)
pFX->SetFieldType(CFieldExchange: utputColumn);
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|