CDBVariant varValue;
CGuestSet m_recordSet ;//CGuestSet派生于CRecordSet类strSQL.Format ("{call SearchGuest_Info('%s')}",m_name);//SearchGuest_Inf为存储过程,使用ODBC调用
m_recordSet.Open (AFX_DB_USE_DEFAULT_TYPE,strSQL);if(m_recordSet.GetRecordCount() != 0)
m_recordSet.MoveFirst();
while ( !m_recordSet.IsEOF())
{
m_recordSet.GetFieldValue((short)0,varValue );//出错提示:结果集不是由Select语句生成
m_basic.InsertItem(i,varValue.m_pstring->GetBuffer(1));
求哪位高手解答~~谢谢
CGuestSet m_recordSet ;//CGuestSet派生于CRecordSet类strSQL.Format ("{call SearchGuest_Info('%s')}",m_name);//SearchGuest_Inf为存储过程,使用ODBC调用
m_recordSet.Open (AFX_DB_USE_DEFAULT_TYPE,strSQL);if(m_recordSet.GetRecordCount() != 0)
m_recordSet.MoveFirst();
while ( !m_recordSet.IsEOF())
{
m_recordSet.GetFieldValue((short)0,varValue );//出错提示:结果集不是由Select语句生成
m_basic.InsertItem(i,varValue.m_pstring->GetBuffer(1));
求哪位高手解答~~谢谢
@G_NAME varchar(30)
AS
SET NOCOUNT ON//后加的
select G_NAME, EMP_COUNTRY,EMP_NATION,EMP_ID,G_NUM,SEX,START_TIME,END_TIME
FROM GUEST
WHERE G_NAME = @G_NAME
GO
这样后也不行