Column lists do not match错误
wwzh 2001-09-27 12:23:41 我在使用以下语句时出现Column lists do not match错误:请教大虾,怎么回事?怎么解决?
string query
query="select rizhi.LOGID,rizhi.OPERATIONTYPE,rizhi.MODULENAME,rizhi.OPERATEDDB,rizhi.OPERATORID,rizhi.OPERATIONDATE,rizhi.OPERATIONTIME,rizhi.SQLSTRING from rizhi where OPERATIONDATE >= '"+bakdate+"' and OPERATIONDATE <= '"+bakdate1+"'"
dw_query.SetTransObject(SQLCA)
dw_query.SetSQLSelect(query)//执行到此句时出现上述错误
dw_query.Retrieve()
把query环城:select * from rizhi where OPERATIONDATE >= '"+bakdate+"' and OPERATIONDATE <= '"+bakdate1+"'"
也一样。