能不能在CRordSet嵌套CRordSet呢?
CRecordset rs(&dbInfo);
CString strFilter;
strFilter.Format("SELECT * FROM [company WHERE [company].[CNumber]=%0.9f ",m_Number);
if (rs.Open(CRecordset::snapshot,
strFilter, CRecordset::readOnly
{
int count=0;
while(!rs.IsEOF())
{
CString strcompany,strnumber;
rs.GetFieldValue("company",strcompany);
rs.GetFieldValue("CNumber",strnumber);
m_Quest.InsertItem(count,strcompany);
m_Quest.SetItemText(count,1,strnumber);
CRecordset rs1(&dbInfo);
CString strFilter1;
strFilter1.Format("SELECT * FROM [lirun] WHERE date=%s",m_times);
if (rs1.Open(CRecordset::snapshot,
strFilter1,CRecordset::readOnly))
{
while(!rs1.IsEOF())
{
CString strshouru,strchengben;
rs1.GetFieldValue("zhuyingshouru",strshouru);
rs1.GetFieldValue("zhuyingchengben",strchengben);
double maolilv;
maolilv=(atof(strshouru)-atof(strchengben))/atof(strshouru)*100 ;
m_Quest.SetItemText(count,2,CString(maolilv));
}
}
rs1.Close();
count++;
rs.MoveNext();
}
rs.Close();
但是程序会跳过rs1这部分。请问应该如何写?
CRecordset rs(&dbInfo);
CString strFilter;
strFilter.Format("SELECT * FROM [company WHERE [company].[CNumber]=%0.9f ",m_Number);
if (rs.Open(CRecordset::snapshot,
strFilter, CRecordset::readOnly
{
int count=0;
while(!rs.IsEOF())
{
CString strcompany,strnumber;
rs.GetFieldValue("company",strcompany);
rs.GetFieldValue("CNumber",strnumber);
m_Quest.InsertItem(count,strcompany);
m_Quest.SetItemText(count,1,strnumber);
CRecordset rs1(&dbInfo);
CString strFilter1;
strFilter1.Format("SELECT * FROM [lirun] WHERE date=%s",m_times);
if (rs1.Open(CRecordset::snapshot,
strFilter1,CRecordset::readOnly))
{
while(!rs1.IsEOF())
{
CString strshouru,strchengben;
rs1.GetFieldValue("zhuyingshouru",strshouru);
rs1.GetFieldValue("zhuyingchengben",strchengben);
double maolilv;
maolilv=(atof(strshouru)-atof(strchengben))/atof(strshouru)*100 ;
m_Quest.SetItemText(count,2,CString(maolilv));
}
}
rs1.Close();
count++;
rs.MoveNext();
}
rs.Close();
但是程序会跳过rs1这部分。请问应该如何写?
解决方案 »
- 一个A表的外键是另一个B表的主键//这个B表的主键取值必须参数A表的外键字段值吗?
- 两个进程间不能用SendMessage传送自定义消息吧!
- 如何用VC2005关闭QQ?
- 求助,关于多文档的全屏问题
- 再问高手:为什么我的IE6不能显示XML文件? 回复请发邮件至[email protected]
- 如何在RichView内正确显示0x80 - 0xFF的ASCII字符?
- 我想问一下假如要买一本mfc类库啥版本的呀 急救
- 在网页中注册OCX控件后,在 html代码中的不同位置调用控件的接口方法,是否有影响?
- 视频采集压缩,午夜求教!
- 哪里有C#的编译器?????火!!!!!!!!!!!!!谢!!
- 请教.这一段程序是什么意思?
- 找相应的消息函数?
strFilter1.Format("SELECT * FROM [lirun] WHERE date='%s'",m_times);
siphonelee(sifone) 能说的详细写么?
注意时间的两边加上单引号 'XXX '
你想,为什么name之类的字段要用单引号?
strFilter1.Format("SELECT * FROM [lirun] WHERE date=#%s#",m_times);
那你把打开rsl的sql语句 SELECT * FROM [lirun] WHERE date=....
在查询分析器里做一下,看看结果如何