I finally found how to do it!!! Jope this is useful for someone:
In the main class: mAcReason = ((AutoCompleteTextView) findViewById(R.id.ac_registerevent_reason)); ContactListAdapter adapter = new ContactListAdapter(this, mCursor); this.mAcReason.setAdapter(adapter); public static class ContactListAdapter extends CursorAdapter implements Filterable { public ContactListAdapter(Context context, Cursor c) { super(context, c); Log.d("exp", "******************* A VER EHJEE *****************"); mDb = new Database(context); mDb.open(); Log.d("exp", "******************* A VER PUES 100 *****************"); } @Override public View newView(Context context, Cursor cursor, ViewGroup parent) { final LayoutInflater inflater = LayoutInflater.from(context); final TextView view = (TextView) inflater.inflate( android.R.layout.simple_dropdown_item_1line, parent, false); Log.d("exp", "******************* A VER 100 *****************"); view.setText(cursor.getString(2)); Log.d("exp", "******************* A VER PUES 150 *****************"); return view; } @Override public void bindView(View view, Context context, Cursor cursor) { Log.d("exp", "******************* A VER 200 *****************"); ((TextView) view).setText(cursor.getString(2)); } @Override public String convertToString(Cursor cursor) { Log.d("exp", "******************* A VER 300 *****************"); return cursor.getString(2); } @Override public Cursor runQueryOnBackgroundThread(CharSequence constraint) { if (getFilterQueryProvider() != null) { Log.d("exp"+constraint, "******************* A VER PUES 800 *****************"); return getFilterQueryProvider().runQuery(constraint); } StringBuilder buffer = null; String[] args = null; /*if (constraint != null) { buffer = new StringBuilder(); buffer.append("UPPER("); Log.d("exp", "******************* A VER 400 *****************"); buffer.append(Database.KEY_REASON); Log.d("exp", "******************* A VER PUES 900 *****************"); buffer.append(") GLOB ?"); args = new String[] { constraint.toString().toUpperCase() + "*" }; //args = "g"; Log.d("exp"+constraint, "******************* A VER PUES 800 *****************"); }*/ Log.d("exp", "******************* A VER 500 *****************"); String where = ""; if (constraint != null) where = constraint.toString(); Log.d("exp"+where, "******************* A VER 500 *****************"); Cursor cur = mDb.fetchCustomEvents("expense", "reason like '" + where + "%'"); Log.d("TOTAL="+cur.getCount(), "******************* A VER 500 *****************"); return cur; } private Database mDb; } private static final String[] PEOPLE_PROJECTION = new String[] { Database.KEY_REASON, Database.KEY_VALUE, Database.KEY_TAX }; On Nov 6, 9:48 pm, "Juan David Trujillo C." <[EMAIL PROTECTED]> wrote: > Hi all!! > > I want to create an autocomplete that gets its information from a > database query. I have a database method that returns the Cursor > (with name, value and date fields) I need, but I dont know how to > actually fill it, so it works as expected as the Contacts API > demo:http://code.google.com/android/samples/ApiDemos/src/com/example/andro... > > I want the autocomplete to show the name field from the database > query. > > I read the following thread, but still haven't been able to figure it > out. > > http://groups.google.com/group/android-developers/browse_thread/threa... > > I have to use the methods: > runQueryOnBackgroundThread, convertToString, among others and extend > extends SimpleCursorAdapter, but I still don't know how to actually > use it. > > Appreciate any help provided!!! > > Best regards, > > Juan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---