rs.Open(CRecordset::dynaset,"select * from Bom order by No desc");
rs.Open(CRecordset::dynaset,"select * from Bom order by No");
我想对Bom表中所有数据按照No项进行排序(在access数据库中)可是查出来的数据并没有排序,为什么呢?哪位大哥大姐教教我如何排序?急呀!
rs.Open(CRecordset::dynaset,"select * from Bom order by No");
我想对Bom表中所有数据按照No项进行排序(在access数据库中)可是查出来的数据并没有排序,为什么呢?哪位大哥大姐教教我如何排序?急呀!
rs.Open(CRecordset::dynaset,"select * from Bom order by No desc");
rs.Open(CRecordset::dynaset,"select * from Bom order by No");
数据是显示出来了,可是这些数据没有按照我所需要的升序/降序排列,需要各位高手帮忙!!
谢了先!
rs.m_strSort = "No";
rs.Open(CRecordset::dynaset,"select * from Bom order by No desc");
rs.Open(CRecordset::dynaset,"select * from Bom order by No");
---------
++C++
---------
rs.m_strSort = "No";
程序运行时提示:系统资源不足,请退出所有程序!
BOOL fOK = m_dbConn.Open("test");//打开数据库
TRACE("connect fOK=%d\n",m_dbConn);CRecordset rs(&m_dbConn);
rs.Open(CRecordset::forwardOnly,"select * from Bom order by No desc");
rs.Open(CRecordset::dynaset,"select * from Bom order by No");
TRACE("connect fOK=%d\n",m_dbConn);
加不加都一样,因为数据是显示了,但还是没有排序
TRACE("connect fOK=%d\n",db);
数据是显示了,但还是没有排序 BOOL fOK = db.Open("DSN=abc");
TRACE("connect fOK=%d\n",db);
或 BOOL fOK = db.Open("abc");
TRACE("connect fOK=%d\n",db);
程序运行时提示:系统资源不足,请退出所有程序!
那排序的过程应该在TreeCtrl来控制.其实我想
rs.Open(CRecordset::forwardOnly,"select * from Bom order by No desc");
所得到的记录是按顺序来排列的,
但是你让它们显示出来时顺序就不会按刚才的排序了,
因为控件有自己的排序方法.