private String buildQuerySql() {
StringBuilder sb = new StringBuilder();
sb.append(
"select _id,subkey,code,name from (select _id,subkey,code,name,date from tb_common a,fundsinfo b where a.subkey=b.code");
sb.append(" and a.key='" + CommenDb_Key + "' order by a.date desc limit 5)");
sb.append(" order by date desc");
LogUtils.d("sql", sb.toString());
return sb.toString();
}
@Override
public boolean onQueryTextChange(String newText) {
// TODO Auto-generated method stub
// mSEditText
if (mCurrFragment != null && mCurrFragment.getmSAdp() != null) {
LogUtils.d("search" + "currfragment2--" + mCurrFragment);
mCurrFragment.getmSAdp().getFilter().filter(newText);
dismissHistory();
}
return true;
}