Thanks... your program worked...
Thank you for your help...
Just one question... If what I understand is correct, your program
queries only the first column of the table... If I query the second
column which is the "_id" column, it still looks into the "name"
column and displays the content of the name column in the autocomplete
textview. So i have to change the ((TextView) view).setText
(cursor.getString(columnIndex)) and return cursor.getString
(columnIndex) to ((TextView) view).setText(cursor.getString(1)) and
return cursor.getString(1)...
I don't know if what I did to modify the code was the correct way or
do you have a better way?
it now looks like this...
@Override
public void bindView(View view, Context context, Cursor
cursor) {
((TextView) view).setText(cursor.getString(1));
}
@Override
public String convertToString(Cursor cursor) {
Log.i("info", " convertToString ");
return cursor.getString(1);
}
@Override
public Cursor runQueryOnBackgroundThread(CharSequence
constraint) {
if (constraint != null) {
String selection = "_id like \'" + constraint.toString()
+"%\'";
return sqlite.query("test", null, selection, null,
null, null, null);
}
else {
return null;
}
}
sorry if im such a noob....
On Mar 13, 5:28 pm, roland <[email protected]> wrote:
> Hi, i made a sample of using a AutoCompleteTextView to showing names
> which are saved in a database.
>
> Here is the link of
> project:http://0467525716.free.fr/Android/AutocompleteTest.zip
>
> I hope it helps.
>
> On 10 mar, 04:26, aljo <[email protected]> wrote:
>
>
>
> > i already saw that thread but i still can't understand some of the
> > codes... i don't know how to incorporate my database in that code...
> > how can i import my db...
>
> > public ContactListAdapter(Context context, Cursor c) {
> > super(context, c);
> > Log.d("exp", "******************* A VER EHJEE
> > *****************");
> > mDb = new Database
> > (context);
> > <------- (is this where i will put my DB?)
> > mDb.open();
> > Log.d("exp", "******************* A VER PUES 100
> > *****************");
> > }
>
> > private static final String[] PEOPLE_PROJECTION = new String[]
> > <----- (is this where autocomplete extracts its data?)
> > {
> > Database.KEY_REASON,
> > Database.KEY_VALUE,
> > Database.KEY_TAX
> > };
>
> > sorry guyz... im kinda new on this whole thing....
> > tnx for any of your help...
>
> > On Mar 5, 6:42 pm, roland <[email protected]> wrote:
>
> > > Check this
> > > out,http://groups.google.com/group/android-developers/browse_thread/threa...
>
> > > On 4 mar, 07:22, aljo <[email protected]> wrote:
>
> > > > i'm kinda new to this android application and still a newbei to
> > > > programming so hope someone could help me....
>
> > > > i've created an SQLitedatabaseprogram.. but i don't know how to use
> > > > theautocompletefunction to access mydatabase... here's my code:
>
> > > > --------------------------------------------------------------------------------------------------------------------------------------
>
> > > > packagedatabase.dev5;
>
> > > > import java.util.ArrayList;
>
> > > > import android.app.ListActivity;
> > > > import android.database.Cursor;
> > > > import android.database.sqlite.SQLiteDatabase;
> > > > import android.os.Bundle;
> > > > import android.widget.ArrayAdapter;
> > > > import android.widget.EditText;
>
> > > > public classDatabaseextends ListActivity {
>
> > > > private final String MY_DATABASE_NAME = "myCoolDB_2";
> > > > private final String MY_DATABASE_TABLE = "Users";
>
> > > > /** Called when the activity is first created. */
> > > > @Override
> > > > public void onCreate(Bundle icicle) {
> > > > super.onCreate(icicle);
>
> > > > EditText et = new EditText(this);
> > > > et.setSelection(et.getText().length());
> > > > /* Will hold the 'Output' we want to display at the
> > > > end. */
> > > > ArrayList<String> results = new ArrayList<String>();
>
> > > > SQLiteDatabase myDB = null;
> > > > try {
>
> > > > //Create theDatabase(no Errors if it already
> > > > exists)
> > > > this.openOrCreateDatabase(MY_DATABASE_NAME,
> > > > MODE_PRIVATE, null);
> > > > // Open the DB and remember it
> > > > myDB =
> > > > this.openOrCreateDatabase(MY_DATABASE_NAME, MODE_PRIVATE,
> > > > null);
>
> > > > //this.deleteDatabase(MY_DATABASE_NAME);
>
> > > > // Create a Table in theDatabase.
> > > > myDB.execSQL("CREATE TABLE IF NOT EXISTS "
> > > > +
> > > > MY_DATABASE_TABLE
> > > > + " (English
> > > > VARCHAR, Japanese VARCHAR,"
> > > > + " MASU_Form
> > > > VARCHAR, Definition VARCHAR);");
>
> > > > //myDB.delete(MY_DATABASE_TABLE, null, null);
>
> > > > // Add two DataSets to the Table.
> > > > /*myDB.execSQL("INSERT INTO "
> > > > +
> > > > MY_DATABASE_TABLE
> > > > + " (English,
> > > > Japanese, MASU_Form, Definition)"
> > > > + " VALUES
> > > > ('yes', 'hai', 'NA', 'noun');");
> > > > myDB.execSQL("INSERT INTO "
> > > > +
> > > > MY_DATABASE_TABLE
> > > > + " (English,
> > > > Japanese, MASU_Form, Definition)"
> > > > + " VALUES
> > > > ('yes', 'ee', 'NA', 'noun');");
> > > > myDB.execSQL("INSERT INTO "
> > > > +
> > > > MY_DATABASE_TABLE
> > > > + " (English,
> > > > Japanese, MASU_Form, Definition)"
> > > > + " VALUES
> > > > ('call', 'kakeru', 'kakemasu', 'verb: to call');");
> > > > myDB.execSQL("INSERT INTO "
> > > > +
> > > > MY_DATABASE_TABLE
> > > > + " (English,
> > > > Japanese, MASU_Form, Definition)"
> > > > + " VALUES
> > > > ('call', 'kakeru', 'kakemasu', 'verb: to wear');");
> > > > myDB.execSQL("INSERT INTO "
> > > > +
> > > > MY_DATABASE_TABLE
> > > > + " (English,
> > > > Japanese, MASU_Form, Definition)"
> > > > + " VALUES
> > > > ('call', 'kakeru', 'kakemasu', 'verb: to
> > > > hang');");*/
>
> > > > //myDB.delete(MY_DATABASE_TABLE, "LastName" +
> > > > "=" + "'Ponce'",
> > > > null);
> > > > //myDB.delete(MY_DATABASE_TABLE, null, null);
>
> > > > //Query for some results with Selection and
> > > > Projection.
> > > > /*Cursor c = myDB.query(MY_DATABASE_TABLE,
> > > > new String[] {"FirstName, Age
> > > > "}, null,
> > > > null, null, null, null, "7");
> > > > */
>
> > > > Cursor c = myDB.query(MY_DATABASE_TABLE,
> > > > new String[] {"English,
> > > > Japanese , MASU_Form, Definition"},
> > > > "Japanese" + "=" + "'kakeru'",
> > > > null, null, null, null, "7");
>
> > > > // Get the indices of the Columns we will need
> > > > int EnglishColumn = c.getColumnIndex("English");
> > > > int JapaneseColumn =
> > > > c.getColumnIndex("Japanese");
> > > > int MASU_FormColumn =
> > > > c.getColumnIndex("MASU_Form");
> > > > int DefinitionColumn =
> > > > c.getColumnIndex("Definition");
>
> > > > // Check if our result was valid.
> > > > if (c != null) {
> > > > //Check if at least one Result was
> > > > returned.
> > > > if (c.moveToFirst()) {
> > > > int i = 0;
> > > > // Loop through all Results
> > > > do {
> > > > i++;
> > > > //Retrieve the values
> > > > of the Entry
> > > > // the Cursor is
> > > > pointing to.
> > > > String english =
> > > > c.getString(EnglishColumn);
> > > > String japanese =
> > > > c.getString(JapaneseColumn);
> > > > String masu_form =
> > > > c.getString(MASU_FormColumn);
> > > > String definition =
> > > > c.getString(DefinitionColumn);
>
> > > > //Add current Entry to
> > > > results.
> > > > results.add("(" + i +
> > > > ") " + english + ", " + japanese + ", " +
> > > > masu_form + ", " + definition);
>
> > > > } while (c.moveToNext());
> > > > }
> > > > }
>
> > > >
>
> ...
>
> read more »- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
