Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 1st, 2012  |  syntax: None  |  size: 1.03 KB  |  hits: 7  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Cursor not closed after filtering
  2. @Override
  3. public Cursor runQueryOnBackgroundThread(CharSequence constraint) {
  4.  
  5.   if (getFilterQueryProvider() != null) {
  6.     return getFilterQueryProvider().runQuery(constraint);
  7.   }
  8.  
  9.   if (constraint == null || constraint.length() == 0) {
  10.     return context.getContentResolver().query(DBContentProvider.URI_LOGS, null,
  11.         LRMDatabase.LogTable.TYPE + " >= " + this.filterType, null, sqlOrder);
  12.   } else {
  13.     return context.getContentResolver().query(
  14.         DBContentProvider.URI_LOGS, null,
  15.         LRMDatabase.LogTable.TYPE + " >= " + this.filterType  + " AND " +
  16.         LRMDatabase.LogTable.MSG + " LIKE '%" + constraint.toString() + "%'", null,
  17.         this.sqlOrder);
  18.   }
  19. }
  20.        
  21. private TextWatcher filterTextWatcher = new TextWatcher() {
  22.   public void afterTextChanged(Editable s) {    
  23.   }
  24.  
  25.   public void beforeTextChanged(CharSequence s, int start, int count, int after) {
  26.   }
  27.  
  28.   public void onTextChanged(CharSequence s, int start, int before, int count) {
  29.     adapter.getFilter().filter(s);
  30.   }
  31. };