只有这样才查得到:
"select * from commu where %s = '%s' ",m_tablefield,m_keyword
换成LIKE后就查不到了,郁闷.
m_keyword2="%"+m_keyword+"%";
select * from commu where %s like '%s' ",m_tablefield,m_keyword2请教
"select * from commu where %s = '%s' ",m_tablefield,m_keyword
换成LIKE后就查不到了,郁闷.
m_keyword2="%"+m_keyword+"%";
select * from commu where %s like '%s' ",m_tablefield,m_keyword2请教
我用ODBC还是好的,但是用DAO就不对了.
CDaoRecordset *rs=new CDaoRecordset(&db);
rs->Open(dbOpenDynaset,"select * from commu where telephone like '%1%'",dbReadOnly);查不到结果,而数据库里是有数据的.
rs->Open(dbOpenDynaset,"select * from commu where telephone = 1388'",dbReadOnly);
这样就查得到.
在access中用*号