怎么解决“试图打开表格失败-未指明要检索的列。”异常?
如何解决“试图打开表格失败--未指明要检索的列。”错误????
CString strSQL = _T( "[列表字段宽度] ");
m_dataRowset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL,CRecordset::none );
m_dataRowset.MoveFirst();
while( !m_dataRowset.IsEOF() )
{
LISTHEADINFO lhi;
lhi.strName = m_dataRowset.strLLHFieldName;
lhi.bWidthMode = m_dataRowset.bLLHWidthMode;
lhi.fWidthPercentum = m_dataRowset.fLLHWidthPercentum;
lhi.nWidthImmobility = m_dataRowset.nLLHWidthImmobility;
m_dataRowset.MoveNext();
}
运行是弹出错误提示框:试图打开表格失败--未指明要检索的列。
------解决方案--------------------
你的SQL table name确定是 "[列表字段宽度] "吗?还是说是 "列表字段宽度 "...
------解决方案--------------------
或者你尝试用其他方式打开看看
MSDN的例子:
Example
The following code examples show different forms of the Open call.
// rs is a CRecordset or
// CRecordset-derived object
// Open rs using the default SQL statement,
// implement bookmarks, and turn off
// automatic dirty field checking
rs.Open( CRecordset::snapshot, NULL,
CRecordset::useBookmarks |
CRecordset::noDirtyFieldCheck );
// Pass a complete SELECT statement
// and open as a dynaset
rs.Open( CRecordset::dynaset,
_T( "Select L_Name from Customer " ) );
// Accept all defaults
rs.Open( );
CString strSQL = _T( "[列表字段宽度] ");
m_dataRowset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL,CRecordset::none );
m_dataRowset.MoveFirst();
while( !m_dataRowset.IsEOF() )
{
LISTHEADINFO lhi;
lhi.strName = m_dataRowset.strLLHFieldName;
lhi.bWidthMode = m_dataRowset.bLLHWidthMode;
lhi.fWidthPercentum = m_dataRowset.fLLHWidthPercentum;
lhi.nWidthImmobility = m_dataRowset.nLLHWidthImmobility;
m_dataRowset.MoveNext();
}
运行是弹出错误提示框:试图打开表格失败--未指明要检索的列。
------解决方案--------------------
你的SQL table name确定是 "[列表字段宽度] "吗?还是说是 "列表字段宽度 "...
------解决方案--------------------
或者你尝试用其他方式打开看看
MSDN的例子:
Example
The following code examples show different forms of the Open call.
// rs is a CRecordset or
// CRecordset-derived object
// Open rs using the default SQL statement,
// implement bookmarks, and turn off
// automatic dirty field checking
rs.Open( CRecordset::snapshot, NULL,
CRecordset::useBookmarks |
CRecordset::noDirtyFieldCheck );
// Pass a complete SELECT statement
// and open as a dynaset
rs.Open( CRecordset::dynaset,
_T( "Select L_Name from Customer " ) );
// Accept all defaults
rs.Open( );