调试程序时出这错：Run-Time Check Failure #2 - Stack around the variable 'tCardInfo' was corrupted.

[huaguli]

具体代码如下：
void CDlgSetCard::FillAcInfo(int iCardPhyId)
//
{
CString sql,cTemp1,cTemp2;
TCardInfo tCardInfo;
int iLockId;
_RecordsetPtr pRs;
_variant_t var;
_bstr_t bstr;
for(int i=0;i<m_iLoSelNum;i++)//lch
{
iLockId = m_pLoSel[i]->GetLockAddr();//lch
cTemp1.Format("%d",iLockId);//lch
cTemp2.Format("%d",iCardPhyId);//lch
sql = "Select * FROM CardInLock WHERE CardPhyid =" + cTemp2 + " and LockId = " + cTemp1;//lch
if(!m_adoacct.GetRecordset(sql,pRs))
{
m_adoacct.CloseRecordset(pRs);
return;
}
while(!pRs->EndOfFile)
{
memset(&tCardInfo,0,sizeof(TCardInfo));
tCardInfo.nComDistrict = 0;
tCardInfo.nDistrict = m_iAreaNo;
tCardInfo.nLock = 0;
var = pRs->GetCollect((_variant_t)_T("CardPhyId"));
tCardInfo.nCardID = var.intVal;

var = pRs->GetCollect((_variant_t)_T("CardType"));
tCardInfo.nCardType = var.bVal;

var = pRs->GetCollect((_variant_t)_T("CardLevel"));
tCardInfo.nCardLevel = var.bVal;

var = pRs->GetCollect((_variant_t)_T("Year"));//lch
tCardInfo.nYear = var.intVal;

var = pRs->GetCollect((_variant_t)_T("Month"));//lch
tCardInfo.nMonth = var.intVal;

var = pRs->GetCollect((_variant_t)_T("Day"));//lch
tCardInfo.nDay = var.intVal;

var = pRs->GetCollect((_variant_t)_T("ScheduleId"));
tCardInfo.nScheduleID = var.bVal;

//lch var = pRs->GetCollect((_variant_t)_T("Name"));
//lch bstr=(var.vt!=VT_NULL) ? var:"";
//lch strcpy(tCardInfo.cName,(char*)bstr);

var = pRs->GetCollect((_variant_t)_T("AccessCode"));
bstr=(var.vt!=VT_NULL) ? var:"";
strcpy(tCardInfo.sAccessCode,(char*)bstr);

m_aAcInfo.Add(tCardInfo);

pRs->MoveNext();

}
m_adoacct.CloseRecordset(pRs);
}
} //单步执行到最后这是出错，我估计是从数据库中取数据填充数据结构TCardInfo时哪类型不匹配

这是TCardInfo结构定义：
ypedef struct tagCardInfo
{
BYTE nComDistrict;
BYTE nDistrict;
BYTE nLock;
char cName[20]; //卡名称
int nCardID; //卡物ID
BYTE nCardType; //卡类型
BYTE nCardLevel; //卡级别
BYTE nScheduleID; //时段ID
CHAR sAccessCode[8]; //卡密码
WORD nYear; //有效日期年
BYTE nMonth; //有效日期月
BYTE nDay; //有效日期日

}TCardInfo,* LPCardInfo;


在数据库中：CardPhyID我设为int类型，长度 4
CardType tinyint 1
CardLevel tinyint 1
ScheduleID tinyint 1
[Year] tinyint 1
[Month] tinyint 1
[Day] tinyint 1
AccessCode char 8

是不是我的数据库长度定义有问题啊？？大家帮我看看，谢谢！

[嗨客递锅]

估计是你对tCardInfo 操作时数据长度超过了限制。再仔细检查一下每次对tCardInfo的操作是否越界。