由于绑定操作是由宏实现的,ADO EXTENTSION 绑定 recordset时需要注意冗余变量问题 ,不慎将导致记录无法出来。
如上代码Point A与Point B之间不能出现冗余变量。否则有可能导致取不到值或者无法显示。
class
CHasPrpRs :
public
CADORecordBinding
{
BEGIN_ADO_BINDING(CHasPrpRs)
ADO_VARIABLE_LENGTH_ENTRY2(1, adVarChar, m_ch_TenantIndividualID,
sizeof(m_ch_TenantIndividualID), m_ul_TenantIndividualIDStatus, true)
ADO_VARIABLE_LENGTH_ENTRY2(2, adVarChar, m_ch_Email,
sizeof(m_ch_Email), m_ul_EmailStatus, true)
ADO_VARIABLE_LENGTH_ENTRY2(3, adVarChar, m_ch_TenantIDNumber,
sizeof(m_ch_TenantIDNumber), m_ul_TenantIDNumberStatus, true)
ADO_VARIABLE_LENGTH_ENTRY2(4 , adVarChar, m_ch_Name ,
sizeof( m_ch_Name), m_ul_NameStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(5 , adVarChar, m_ch_Salutation ,
sizeof( m_ch_Salutation ), m_ul_SalutationStatus, true)
ADO_VARIABLE_LENGTH_ENTRY2(6 , adVarChar, m_ch_Country ,
sizeof( m_ch_Country ), m_ul_CountryStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(7 , adVarChar, m_ch_Phone ,
sizeof( m_ch_Phone ), m_ul_PhoneStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(8 , adVarChar, m_ch_CellPhone ,
sizeof( m_ch_CellPhone ), m_ul_CellPhoneStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(9 , adVarChar, m_ch_Fax ,
sizeof( m_ch_Fax ), m_ul_FaxStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(10 , adVarChar, m_ch_PHS ,
sizeof( m_ch_PHS ), m_ul_PHSStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(11 , adVarChar, m_ch_MoveInDate ,
sizeof( m_ch_MoveInDate ), m_ul_MoveInDateStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(12 , adVarChar, m_ch_Company ,
sizeof( m_ch_Company ), m_ul_CompanyStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(13 , adVarChar, m_ch_Actived ,
sizeof( m_ch_Actived ), m_ul_Actived , true)
ADO_VARIABLE_LENGTH_ENTRY2(14 , adVarChar, m_ch_MemberID ,
sizeof( m_ch_MemberID ), m_ul_MemberIDStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(15 , adVarChar, m_ch_Language ,
sizeof( m_ch_Language ), m_ul_LanguageStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(16 , adVarChar, m_ch_Marriage ,
sizeof( m_ch_Marriage ), m_ul_MarriageStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(17 , adVarChar, m_ch_Occupation ,
sizeof( m_ch_Occupation ), m_ul_OccupationStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(18 , adVarChar, m_ch_newsletter ,
sizeof( m_ch_newsletter ), m_ul_newsletterStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(19 , adVarChar, m_ch_Gender ,
sizeof( m_ch_Gender ), m_ul_GenderStatus , true)
END_ADO_BINDING()
public:
//<---------------------------------------------------------------------------Point A
TCHAR m_ch_TenantIndividualID[20]; //1
TCHAR m_ch_Email[50]; //2
TCHAR m_ch_TenantIDNumber[50]; //3
TCHAR m_ch_Name[150]; //4
TCHAR m_ch_Salutation[10]; //5
TCHAR m_ch_Country[50]; //6
TCHAR m_ch_Phone[50]; //7
TCHAR m_ch_CellPhone[50]; //8
TCHAR m_ch_Fax[50]; //9
TCHAR m_ch_PHS[50]; //10
TCHAR m_ch_MoveInDate[20];//datetime //11
TCHAR m_ch_Company[20]; //12
TCHAR m_ch_Actived[1]; //13
TCHAR m_ch_MemberID[20]; //14
TCHAR m_ch_Language[10]; //15
TCHAR m_ch_Marriage[10]; //16
TCHAR m_ch_Occupation[10]; //17
TCHAR m_ch_newsletter[10]; //18
TCHAR m_ch_Gender[1]; //19
//int m_i_TenantIndividualID;
//<--------------------------------------------------------------------------------------------------------------Point B
ULONG m_ul_TenantIndividualIDStatus; //1
ULONG m_ul_EmailStatus; //2
ULONG m_ul_TenantIDNumberStatus; //3
ULONG m_ul_NameStatus; //4
ULONG m_ul_SalutationStatus; //5
ULONG m_ul_CountryStatus; //6
ULONG m_ul_PhoneStatus; //7
ULONG m_ul_CellPhoneStatus; //8
ULONG m_ul_FaxStatus; //9
ULONG m_ul_PHSStatus; //10
ULONG m_ul_MoveInDateStatus; //datetime //11
ULONG m_ul_CompanyStatus; //12
ULONG m_ul_Actived ; //13
ULONG m_ul_MemberIDStatus; //14
ULONG m_ul_LanguageStatus; //15
ULONG m_ul_MarriageStatus; //16
ULONG m_ul_OccupationStatus; //17
ULONG m_ul_newsletterStatus; //18
ULONG m_ul_GenderStatus; //19
public:
inline void Init()
{
//m_i_TenantIndividualID=0;
memset(m_ch_TenantIndividualID,0,sizeof(m_ch_TenantIndividualID)); //1
memset(m_ch_Email,0,sizeof(m_ch_Email)); //2
memset(m_ch_TenantIDNumber,0,sizeof(m_ch_TenantIDNumber)); //3
memset(m_ch_Name,0,sizeof(m_ch_Name)); //4
memset(m_ch_Salutation,0,sizeof(m_ch_Salutation)); //5
memset(m_ch_Country,0,sizeof(m_ch_Country)); //6
memset(m_ch_Phone,0,sizeof(m_ch_Phone)); //7
memset(m_ch_CellPhone,0,sizeof(m_ch_CellPhone)); //8
memset(m_ch_Fax,0,sizeof(m_ch_Fax)); //9
memset(m_ch_PHS,0,sizeof(m_ch_PHS)); //10
memset(m_ch_MoveInDate,0,sizeof(m_ch_MoveInDate));//datetime //11
memset(m_ch_Company,0,sizeof(m_ch_Company)); //12
memset(m_ch_Actived,0,sizeof(m_ch_Actived)); //13
memset(m_ch_MemberID,0,sizeof(m_ch_MemberID)); //14
memset(m_ch_Language,0,sizeof(m_ch_Language)); //15
memset(m_ch_Marriage,0,sizeof(m_ch_Marriage)); //16
memset(m_ch_Occupation,0,sizeof(m_ch_Occupation)); //17
memset(m_ch_newsletter,0,sizeof(m_ch_newsletter)); //18
memset(m_ch_Gender,0,sizeof(m_ch_Gender)); //19
}
CHasPrpRs()
{
Init();
};
virtual ~CHasPrpRs() {};
} ;
{
BEGIN_ADO_BINDING(CHasPrpRs)
ADO_VARIABLE_LENGTH_ENTRY2(1, adVarChar, m_ch_TenantIndividualID,
sizeof(m_ch_TenantIndividualID), m_ul_TenantIndividualIDStatus, true)
ADO_VARIABLE_LENGTH_ENTRY2(2, adVarChar, m_ch_Email,
sizeof(m_ch_Email), m_ul_EmailStatus, true)
ADO_VARIABLE_LENGTH_ENTRY2(3, adVarChar, m_ch_TenantIDNumber,
sizeof(m_ch_TenantIDNumber), m_ul_TenantIDNumberStatus, true)
ADO_VARIABLE_LENGTH_ENTRY2(4 , adVarChar, m_ch_Name ,
sizeof( m_ch_Name), m_ul_NameStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(5 , adVarChar, m_ch_Salutation ,
sizeof( m_ch_Salutation ), m_ul_SalutationStatus, true)
ADO_VARIABLE_LENGTH_ENTRY2(6 , adVarChar, m_ch_Country ,
sizeof( m_ch_Country ), m_ul_CountryStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(7 , adVarChar, m_ch_Phone ,
sizeof( m_ch_Phone ), m_ul_PhoneStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(8 , adVarChar, m_ch_CellPhone ,
sizeof( m_ch_CellPhone ), m_ul_CellPhoneStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(9 , adVarChar, m_ch_Fax ,
sizeof( m_ch_Fax ), m_ul_FaxStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(10 , adVarChar, m_ch_PHS ,
sizeof( m_ch_PHS ), m_ul_PHSStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(11 , adVarChar, m_ch_MoveInDate ,
sizeof( m_ch_MoveInDate ), m_ul_MoveInDateStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(12 , adVarChar, m_ch_Company ,
sizeof( m_ch_Company ), m_ul_CompanyStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(13 , adVarChar, m_ch_Actived ,
sizeof( m_ch_Actived ), m_ul_Actived , true)
ADO_VARIABLE_LENGTH_ENTRY2(14 , adVarChar, m_ch_MemberID ,
sizeof( m_ch_MemberID ), m_ul_MemberIDStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(15 , adVarChar, m_ch_Language ,
sizeof( m_ch_Language ), m_ul_LanguageStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(16 , adVarChar, m_ch_Marriage ,
sizeof( m_ch_Marriage ), m_ul_MarriageStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(17 , adVarChar, m_ch_Occupation ,
sizeof( m_ch_Occupation ), m_ul_OccupationStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(18 , adVarChar, m_ch_newsletter ,
sizeof( m_ch_newsletter ), m_ul_newsletterStatus , true)
ADO_VARIABLE_LENGTH_ENTRY2(19 , adVarChar, m_ch_Gender ,
sizeof( m_ch_Gender ), m_ul_GenderStatus , true)
END_ADO_BINDING()
public:
//<---------------------------------------------------------------------------Point A
TCHAR m_ch_TenantIndividualID[20]; //1
TCHAR m_ch_Email[50]; //2
TCHAR m_ch_TenantIDNumber[50]; //3
TCHAR m_ch_Name[150]; //4
TCHAR m_ch_Salutation[10]; //5
TCHAR m_ch_Country[50]; //6
TCHAR m_ch_Phone[50]; //7
TCHAR m_ch_CellPhone[50]; //8
TCHAR m_ch_Fax[50]; //9
TCHAR m_ch_PHS[50]; //10
TCHAR m_ch_MoveInDate[20];//datetime //11
TCHAR m_ch_Company[20]; //12
TCHAR m_ch_Actived[1]; //13
TCHAR m_ch_MemberID[20]; //14
TCHAR m_ch_Language[10]; //15
TCHAR m_ch_Marriage[10]; //16
TCHAR m_ch_Occupation[10]; //17
TCHAR m_ch_newsletter[10]; //18
TCHAR m_ch_Gender[1]; //19
//int m_i_TenantIndividualID;
//<--------------------------------------------------------------------------------------------------------------Point B
ULONG m_ul_TenantIndividualIDStatus; //1
ULONG m_ul_EmailStatus; //2
ULONG m_ul_TenantIDNumberStatus; //3
ULONG m_ul_NameStatus; //4
ULONG m_ul_SalutationStatus; //5
ULONG m_ul_CountryStatus; //6
ULONG m_ul_PhoneStatus; //7
ULONG m_ul_CellPhoneStatus; //8
ULONG m_ul_FaxStatus; //9
ULONG m_ul_PHSStatus; //10
ULONG m_ul_MoveInDateStatus; //datetime //11
ULONG m_ul_CompanyStatus; //12
ULONG m_ul_Actived ; //13
ULONG m_ul_MemberIDStatus; //14
ULONG m_ul_LanguageStatus; //15
ULONG m_ul_MarriageStatus; //16
ULONG m_ul_OccupationStatus; //17
ULONG m_ul_newsletterStatus; //18
ULONG m_ul_GenderStatus; //19
public:
inline void Init()
{
//m_i_TenantIndividualID=0;
memset(m_ch_TenantIndividualID,0,sizeof(m_ch_TenantIndividualID)); //1
memset(m_ch_Email,0,sizeof(m_ch_Email)); //2
memset(m_ch_TenantIDNumber,0,sizeof(m_ch_TenantIDNumber)); //3
memset(m_ch_Name,0,sizeof(m_ch_Name)); //4
memset(m_ch_Salutation,0,sizeof(m_ch_Salutation)); //5
memset(m_ch_Country,0,sizeof(m_ch_Country)); //6
memset(m_ch_Phone,0,sizeof(m_ch_Phone)); //7
memset(m_ch_CellPhone,0,sizeof(m_ch_CellPhone)); //8
memset(m_ch_Fax,0,sizeof(m_ch_Fax)); //9
memset(m_ch_PHS,0,sizeof(m_ch_PHS)); //10
memset(m_ch_MoveInDate,0,sizeof(m_ch_MoveInDate));//datetime //11
memset(m_ch_Company,0,sizeof(m_ch_Company)); //12
memset(m_ch_Actived,0,sizeof(m_ch_Actived)); //13
memset(m_ch_MemberID,0,sizeof(m_ch_MemberID)); //14
memset(m_ch_Language,0,sizeof(m_ch_Language)); //15
memset(m_ch_Marriage,0,sizeof(m_ch_Marriage)); //16
memset(m_ch_Occupation,0,sizeof(m_ch_Occupation)); //17
memset(m_ch_newsletter,0,sizeof(m_ch_newsletter)); //18
memset(m_ch_Gender,0,sizeof(m_ch_Gender)); //19
}
CHasPrpRs()
{
Init();
};
virtual ~CHasPrpRs() {};
} ;