Database

dragon · by **dragon** » Wed Jan 16, 2008 9:10 pm

Hello anyone,

i'am newbi coding android i'am coding in C++.
I have a main layout with several TextViews and a serch button at the bottom.
I have also a dialog with several spinners with items and a Ok button.
I chose in the spinners with items i want.
The items will be search in a database i created.
If the items are found i want to display the items in TextViews in my main layout.
But i don't see anything in my main layout.
Maybe i missing something!
I have no errors.

This is a part of my java code.

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

@Override
 
    public void onCreate(Bundle icicle) {
 
        super.onCreate(icicle);
 
        setTheme(android.R.style.Theme_Dark);
 
        setContentView(R.layout.main);
 
        mattext=(EditText) this.findViewById(R.id.matet);
 
        koeltext=(TextView) this.findViewById(R.id.koelet);
 
        hardheidtext=(TextView) this.findViewById(R.id.hardheidet);
 
        snijtext=(TextView) this.findViewById(R.id.snijet);
 
        snedebtext=(TextView) this.findViewById(R.id.snedebet);
 
        snededtext=(TextView) this.findViewById(R.id.snededet);
 
        tandtext=(TextView) this.findViewById(R.id.tandet);
 
        voedtext=(TextView) this.findViewById(R.id.voedet);
 
        freesbtext=(TextView) this.findViewById(R.id.freesbet);
 
        diatext=(TextView) this.findViewById(R.id.diaet);
 
        trektext=(TextView) this.findViewById(R.id.treket);
 
        freesttext=(TextView) this.findViewById(R.id.freestet);
 
                Button button =(Button) this.findViewById(R.id.zoek); 
 
        button.setOnClickListener(new View.OnClickListener(){  
 
                public void onClick(View arg0) {
 
                        zoek();
 
                   }
 
                }); 
 
    }
 
public void zoek()
 
 {
 
         final Dialog freesDialog = new Dialog(this);
 
         freesDialog.setTitle("Gegevens");
 
         freesDialog.setContentView(R.layout.dialog);
 
         freesDialog.show();
 
         Button okbutton =(Button) freesDialog.findViewById(R.id.Ok);
 
         okbutton.setOnClickListener(new View.OnClickListener(){  
 
                public void onClick(View view) { 
 
                        freesDialog.dismiss();
 
                                   }
 
                });
 
         String freest = null;
 
         Spinner matSpinner=(Spinner)freesDialog.findViewById(R.id.spinnermat);
 
         Spinner freestSpinner=(Spinner)freesDialog.findViewById(R.id.spinnerfrees);
 
         Spinner diaSpinner=(Spinner)freesDialog.findViewById(R.id.spinnerdia);
 
         Spinner tandSpinner=(Spinner)freesDialog.findViewById(R.id.spinnertand);
 
         Spinner freesbSpinner=(Spinner)freesDialog.findViewById(R.id.spinnerfreesb);
 
         ArrayAdapter<CharSequence> matadapter = ArrayAdapter.createFromResource(
 
             this, R.array.mat, android.R.layout.simple_spinner_item);
 
     matadapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
 
     matSpinner.setAdapter(matadapter);
 
         ArrayAdapter<CharSequence> freestadapter = ArrayAdapter.createFromResource(
 
             this, R.array.frees, android.R.layout.simple_spinner_item);
 
     freestadapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
 
     freestSpinner.setAdapter(freestadapter);
 
     ArrayAdapter<CharSequence> diamadapter = ArrayAdapter.createFromResource(
 
             this, R.array.dia, android.R.layout.simple_spinner_item);
 
     diamadapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
 
     diaSpinner.setAdapter(diamadapter);
 
     ArrayAdapter<CharSequence> tandadapter = ArrayAdapter.createFromResource(
 
             this, R.array.tand, android.R.layout.simple_spinner_item);
 
     tandadapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
 
     tandSpinner.setAdapter(tandadapter);
 
     ArrayAdapter<CharSequence> bewerkadapter = ArrayAdapter.createFromResource(
 
             this, R.array.bewerk, android.R.layout.simple_spinner_item);
 
     bewerkadapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
 
     freesbSpinner.setAdapter(bewerkadapter);
 
                SQLiteDatabase myDB = null;
 
                try {
 
                        this.createDatabase(MY_DATABASE_NAME, 1, MODE_PRIVATE, null);
 
                        myDB = this.openDatabase(MY_DATABASE_NAME, null);
 
                        myDB.execSQL("CREATE TABLE IF NOT EXITS "
 
                                        + MY_DATABASE_TABLE
 
                                        + "(freestype VARCHAR, freesdiameter VARCHAR, aantaltanden VARCHAR, "
 
                                        + "materiaal VARCHAR, hardheid VARCHAR, treksterkte VARCHAR,"
 
                                        + "koeling VARCHAR, freesbewerking VARCHAR, snijsnelheid VARCHAR,"
 
                                        + "snedediepte VARCHAR, snedebreedte VARCHAR, voedingpertand VARCHAR);");
 
                        myDB.execSQL("INSERT INTO "
 
                                        + MY_DATABASE_TABLE
 
                                        + "(freestype, freesdiameter, aantaltanden, materiaal, hardheid, treksterkte,"
 
                                        + "koeling, freesbewerking snijsnelheid, snedediepte, snedebreedte, voedingpertand)"
 
                                        + "VALUES('ECP', '12', '4', 'C45', '180', '350-800'', 'Nee', 'Contour frezen', '160', '16', '4', '0.05');");
 
                        myDB.execSQL("INSERT INTO "
 
                                        + MY_DATABASE_TABLE
 
                                        + "(freestype, freesdiameter, aantaltanden, materiaal, hardheid, treksterkte,"
 
                                        + "koeling, freesbewerking snijsnelheid, snedediepte, snedebreedte, voedingpertand)"
 
                                        + "VALUES('ERF', '16', '4', 'C60', '180', '350-800'', 'Nee', 'Gleuf frezen', '200', '20', '4', '0.05');");
 
                        Cursor c = myDB.query("SELECT + FROM + MY_DATABASE_TABLE + WHERE freestype='" + freestSpinner.getSelectedItemIndex() + "'AND freesdiameter='" + diaSpinner.getSelectedItemIndex() + "'AND aantaltanden='" + tandSpinner.getSelectedItemIndex() + "'AND materiaal='" + matSpinner.getSelectedItemIndex() + "'AND  freesbewerking='" + freesbSpinner.getSelectedItemIndex() + "';",null);  // Maybe the select statement is wrong?
 
                                        int freestypeNameColumn = c.getColumnIndex("freestype");
 
                                        int freesdiameterNameColumn = c.getColumnIndex("freesdiameter");
 
                                        int aantaltandenNameColumn = c.getColumnIndex("aantaltanden");
 
                                        int materiaalNameColumn = c.getColumnIndex("materiaal");
 
                                        int hardheidNameColumn = c.getColumnIndex("hardheid");
 
                                        int treksterkteNameColumn = c.getColumnIndex("treksterkte");
 
                                        int koelingNameColumn = c.getColumnIndex("koeling");
 
                                        int freesbewerkingNameColumn = c.getColumnIndex("freesbewerking");
 
                                        int snijsnelheidNameColumn = c.getColumnIndex("snijsnelheid");
 
                                        int snedediepteNameColumn = c.getColumnIndex("snedediepte");
 
                                        int snedebreedteNameColumn = c.getColumnIndex("snedebreedte");
 
                                        int voedingpertandNameColumn = c.getColumnIndex("voedingpertand");
 
                        c.first();
 
                                do {
 
                                freest = c.getString(freestypeNameColumn);
 
                                freesttext.setText(freest);
 
                                String freesd = c.getString(freesdiameterNameColumn);
 
                                diatext.setText(freesd);
 
                                String aantal = c.getString(aantaltandenNameColumn);
 
                                tandtext.setText(aantal);
 
                                String mat= c.getString(materiaalNameColumn);
 
                                mattext.setText(mat);
 
                                String trek = c.getString(treksterkteNameColumn);
 
                                trektext.setText(trek);
 
                                String hardh = c.getString(hardheidNameColumn);
 
                                hardheidtext.setText(hardh);
 
                                String koel = c.getString(koelingNameColumn);
 
                                koeltext.setText(koel);
 
                                String freesb = c.getString(freesbewerkingNameColumn);
 
                                freesbtext.setText(freesb);
 
                                String snijsnel = c.getString(snijsnelheidNameColumn);
 
                                snijtext.setText(snijsnel);
 
                                String sneded = c.getString(snedediepteNameColumn);
 
                                snededtext.setText(sneded);
 
                                String snedeb = c.getString(snedebreedteNameColumn);
 
                                snedebtext.setText(snedeb);
 
                                String voeding = c.getString(voedingpertandNameColumn);
 
                                voedtext.setText(voeding);
 
                                } while(c.next());      
 
        }catch (FileNotFoundException e)  {
 
        } finally {
 
                if (myDB != null)
 
                        myDB.close();
 
        }
 
 }
 
}
Parsed in 0.058 seconds,  using GeSHi 1.0.8.4

plusminus · by **plusminus** » Wed Jan 16, 2008 11:32 pm

Hello dragon,

[Edit]New Answer[/Edit]
Now I see your bug, it is the statement:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

Cursor c = myDB.query("SELECT + FROM + MY_DATABASE_TABLE + WHERE ...
Parsed in 0.031 seconds,  using GeSHi 1.0.8.4

should be like:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

Cursor c = myDB.query("SELECT FROM " + MY_DATABASE_TABLE + "WHERE ...
Parsed in 0.033 seconds,  using GeSHi 1.0.8.4

I would have assumed that an Runtime-Exception would have occured, but as you said non occured.

Let us know if this helped you.

[Edit]Old Answer[/Edit]

did you ensure with debugging, that your code reaches this part (note that you override the text that would be displayed on every cycle of the do-while loop )

Syntax: [ Download ] [ Hide ]
Syntax: [ Download ] [ Show ]
Using java Syntax Highlighting

c.first();

do {

freest = c.getString(freestypeNameColumn);

freesttext.setText(freest);

String freesd = c.getString(freesdiameterNameColumn);

diatext.setText(freesd);

String aantal = c.getString(aantaltandenNameColumn);

tandtext.setText(aantal);

//...

String snedeb = c.getString(snedebreedteNameColumn);

snedebtext.setText(snedeb);

String voeding = c.getString(voedingpertandNameColumn);

voedtext.setText(voeding);

} while(c.next());

Parsed in 0.037 seconds, using GeSHi 1.0.8.4

Place some Debug-lines within, like:

Syntax: [ Download ] [ Hide ]
Syntax: [ Download ] [ Show ]
Using java Syntax Highlighting

c.first();

do {

freest = c.getString(freestypeNameColumn);

freesttext.setText(freest);

// Do Debug

Log.d("DEBUGTAG", "Called 'freesttext.setText(freest);'"

+ " with freest='" + freest + "'.");

//...

} while(c.next());

Parsed in 0.037 seconds, using GeSHi 1.0.8.4

Regards,
plusminus

dragon · by **dragon** » Thu Jan 17, 2008 6:08 pm

Hello,

I have changed the Select statement in the query.
I have also insert debug lines.
I have no errors butt still i don't see anything in main layout.

This part off my main.xml
I use RelativeLayout.

Syntax: [ Download ] [ Hide ]

Using xml Syntax Highlighting

 
<?xml version="1.0" encoding="utf-8"?>
 
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
 
    android:layout_width="fill_parent"
 
    android:layout_height="fill_parent"
 
    >
 
                        <TextView id="@+id/gegevenslabel"
 
                        android:layout_width="fill_parent" 
 
                        android:layout_height="wrap_content"
 
                        android:textAlign="center"
 
                        android:textColor="@drawable/yellow"
 
                        android:padding="7px"
 
                        android:text="Frees gegevens"/> 
 
                        <TextView id="@+id/freestlabel"
 
                        android:layout_width="fill_parent" 
 
                        android:layout_height="wrap_content"
 
                        android:textColor="@drawable/white"
 
                        android:layout_below="@id/gegevenslabel"
 
                        android:paddingBottom="2px"
 
                        android:text="Freestype:" />
 
                        <TextView id="@+id/freestet"  // This one off 7 Textviews.
 
                        android:layout_height="23px" 
 
                        android:layout_width="120px"
 
                        android:textSize="12px"
 
                        android:layout_below="@id/gegevenslabel"
 
                        android:layout_alignRight="@id/freestlabel"/>
 
                        <TextView id="@+id/dialabel"
 
                        android:layout_width="fill_parent" 
 
                        android:layout_height="wrap_content"
 
                        android:textColor="@drawable/white"
 
                        android:layout_below="@id/freestlabel"
 
                        android:paddingBottom="2px"
 
                        android:text="Frees diameter (D):" />
 
                        <TextView id="@+id/diaet"  // This one TextView i used
 
                        android:layout_height="22px" 
 
                        android:layout_width="40px"
 
                        android:textSize="12px"
 
                        android:layout_below="@id/freestet"
 
                        android:layout_alignRight="@id/dialabel"/>
 
                        <TextView id="@+id/tandlabel"
 
                        android:layout_width="fill_parent" 
 
                        android:layout_height="wrap_content"
 
                        android:textColor="@drawable/white"
 
                        android:layout_below="@id/dialabel"
 
                        android:paddingBottom="2px"
 
                        android:text="Aantal tanden (z):" />
 
                        <TextView id="@+id/tandet" //This one off 7 TextViews
 
                        android:layout_height="22px" 
 
                        android:layout_width="40px"
 
                        android:textSize="12px"
 
                        android:layout_below="@id/diaet"
 
                        android:layout_alignRight="@id/dialabel"/>
Parsed in 0.008 seconds,  using GeSHi 1.0.8.4

Any suggestions.
Thanks in advance.

plusminus · by **plusminus** » Thu Jan 17, 2008 9:12 pm

Hello dragon,

my fault, there is another(actually two) error in the sql-statement, you need to specify the columns you want to retrieve (or " * " for all):

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

Cursor c = myDB.query("SELECT FROM " + MY_DATABASE_TABLE + "WHERE ...
 
// Change to ( Added " * ", and space before "WHERE" )
 
Cursor c = myDB.query("SELECT * FROM " + MY_DATABASE_TABLE + " WHERE ...
Parsed in 0.036 seconds,  using GeSHi 1.0.8.4

Could be a good reason for the fact nothing is being displayed.

If it still doesn't work, remove the "WHERE ... = ..."-Clause from your statement, to further simplify it.

Let us know if you get this thing solved.

Regards,
plusminus

dragon · by **dragon** » Sun Jan 20, 2008 7:19 pm

I think i found something strange with the creation off a database.

I have sample databasework that works fine.
If i go to the commandline adb shell and cd to the database off databasework that is not a problem.
if i type ls i see this line.
drwxrwx--x app_12 2008-01-18 databases // that is Ok i can cd to database.

But if i use my app frezen in commandline adb shell.
I cd/data/data/com.google.android.frezen
If i type ls i see this line.
-rw-r--r-- root 0 2008-01-18 databases // that is not Ok i can't cd to databases
I think my app can't reach the database because is not directory and not exutable and don't have app_number.
This is a strange behavior because the Java coding is correct.

Any idea

Thanks in advance

cabernet1976 · by **cabernet1976** » Fri Jan 25, 2008 2:37 am

Hi dragon,

If your program make some exception and cannot operate database again (i.e. cannot open database or insert record), just try to use adb to rmdir whole of the directory: /data/data/your-package/, then run the program again.

Good luck.

dragon · by **dragon** » Tue Jan 29, 2008 6:28 pm

I solved the problem with the database i can use the database.
But still i have a problem with my spinners.
I use my spinners in a dialog to find in the database the items and display them in the main layout

code snippet

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

SQLiteDatabase myDB = null;
 
                try {
 
                        /* Create the Database (no Errors if it already exists) */ 
 
                        this.createDatabase(MY_DATABASE_NAME, 1, 0, null);
 
                        /* Open the DB and remember it */
 
                        myDB = this.openDatabase(MY_DATABASE_NAME, null);
 
                        myDB.execSQL("CREATE TABLE IF NOT EXISTS "
 
                                        + MY_DATABASE_TABLE
 
                                        + "(freestype VARCHAR, freesdiameter VARCHAR, aantaltanden VARCHAR, "
 
                                        + "materiaal VARCHAR, hardheid VARCHAR, treksterkte VARCHAR,"
 
                                        + "koeling VARCHAR, freesbewerking VARCHAR, snijsnelheid VARCHAR,"
 
                                        + "snedediepte VARCHAR, snedebreedte VARCHAR, voedingpertand VARCHAR);");
 
                        myDB.execSQL("INSERT INTO "
 
                                        + MY_DATABASE_TABLE
 
                                        + "(freestype, freesdiameter, aantaltanden, materiaal, hardheid, treksterkte,"
 
                                        + "koeling, freesbewerking, snijsnelheid, snedediepte, snedebreedte, voedingpertand)"
 
                                        + "VALUES('ECP', '12', '4', 'C45', '180', '350-800', 'Nee', 'Contour frezen', '160', '16', '4', '0.05');");
 
                        myDB.execSQL("INSERT INTO "
 
                                        + MY_DATABASE_TABLE
 
                                        + "(freestype, freesdiameter, aantaltanden, materiaal, hardheid, treksterkte,"
 
                                        + "koeling, freesbewerking, snijsnelheid, snedediepte, snedebreedte, voedingpertand)"
 
                                        + "VALUES('ERF', '16', '4', 'C60', '180', '350-800', 'Nee', 'Gleuf frezen', '160', '16', '4', '0.07');");
 
                        myDB.execSQL("INSERT INTO "
 
                                        + MY_DATABASE_TABLE
 
                                        + "(freestype, freesdiameter, aantaltanden, materiaal, hardheid, treksterkte,"
 
                                        + "koeling, freesbewerking, snijsnelheid, snedediepte, snedebreedte, voedingpertand)"
 
                                        + "VALUES('ERF', '16', '4', 'St37-2', '180', '350-800', 'Nee', 'Contour frezen', '160', '16', '4', '0.07');");
 
                        Cursor c = myDB.query("SELECT * FROM " + MY_DATABASE_TABLE + " WHERE materiaal='" + matSpinner.getSelectedItemIndex()+ "';" ,null);     
 
                        /* Get the indices of the Columns we will need */
 
                        int freestypeNameColumn = c.getColumnIndex("freestype");
 
                        int freesdiameterNameColumn = c.getColumnIndex("freesdiameter");
 
                        int aantaltandenNameColumn = c.getColumnIndex("aantaltanden");
 
                        int materiaalNameColumn = c.getColumnIndex("materiaal");
 
                        int hardheidNameColumn = c.getColumnIndex("hardheid");
 
                        int treksterkteNameColumn = c.getColumnIndex("treksterkte");
 
                        int koelingNameColumn = c.getColumnIndex("koeling");
 
                        int freesbewerkingNameColumn = c.getColumnIndex("freesbewerking");
 
                        int snijsnelheidNameColumn = c.getColumnIndex("snijsnelheid");
 
                        int snedediepteNameColumn = c.getColumnIndex("snedediepte");
 
                        int snedebreedteNameColumn = c.getColumnIndex("snedebreedte");
 
                        int voedingpertandNameColumn = c.getColumnIndex("voedingpertand");
 
                        String freest = null;
 
                                /* Check if at least one Result was returned. */ 
 
                                if (c.first()) {
 
                                        /* Loop through all Results */ 
 
                                        if (c.next())
 
                                                freest = c.getString(freestypeNameColumn);
 
                                                freesttext.setText(freest);
 
                                                String freesd = c.getString(freesdiameterNameColumn);
 
                                        diatext.setText(freesd);
 
                                        String aantal = c.getString(aantaltandenNameColumn);
 
                                        tandtext.setText(aantal);
 
                                        String mat= c.getString(materiaalNameColumn);
 
                                        mattext.setText(mat);
 
                                        String hardh = c.getString(hardheidNameColumn);
 
                                        hardheidtext.setText(hardh);
 
                                        String trek = c.getString(treksterkteNameColumn);
 
                                        trektext.setText(trek);
 
                                        String koel = c.getString(koelingNameColumn);
 
                                        koeltext.setText(koel);
 
                                        String freesb = c.getString(freesbewerkingNameColumn);
 
                                        freesbtext.setText(freesb);     
 
                                        String snijsnel = c.getString(snijsnelheidNameColumn);
 
                                        snijtext.setText(snijsnel);
 
                                        String sneded = c.getString(snedediepteNameColumn);
 
                                        snededtext.setText(sneded);
 
                                        String snedeb = c.getString(snedebreedteNameColumn);
 
                                        snedebtext.setText(snedeb);
 
                                        String voeding = c.getString(voedingpertandNameColumn);
 
                                        voedtext.setText(voeding);
 
                                        }
Parsed in 0.050 seconds,  using GeSHi 1.0.8.4

if i run this application then its popup the dialog with the spinners.
if i choose a item i wnat look for in the database then nothing showing up in the main layout.
If i look in the adb logcat then following line is showing:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

W/SQLiteDirectCursorDriver( 548); Found Sql string that ends in ; --SELECT * FROM test WHERE materiaal='0'
Parsed in 0.035 seconds,  using GeSHi 1.0.8.4

I have in my matSpinner severals items, "C45", "C60", "St37-2"etc..
Is it possibly that i missing something.

Thanks in advance.

plusminus · by **plusminus** » Tue Jan 29, 2008 8:23 pm

Hello dragon,

you are using matSpinner.getSelectedItemIndex() (what returns just the index of the selected item) in the WHERE-Clause. You should probably be using matSpinner.getSelectedItem().toString() instead.

Perhaps this solves your problem. :?:

Regards,
plusminus

dragon · by **dragon** » Fri Feb 01, 2008 4:45 pm

Ok it works for a part of the application.
I have only one question about selecting item in the spinner.
I have read several threads about onItemSelecetListener in this forum.
Now i only see the first item in de spinner, i have read you must use onItemSelectListener to get another item for selecting.

I use now on this moment

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

public void zoek()
 
{
 
         final Dialog freesDialog = new Dialog(this);
 
         freesDialog.setTitle("Gegevens");
 
         freesDialog.setContentView(R.layout.dialog);
 
         freesDialog.show();
 
         Button okbutton =(Button) freesDialog.findViewById(R.id.Ok);
 
         okbutton.setOnClickListener(new View.OnClickListener(){  
 
                public void onClick(View view) { 
 
                        freesDialog.dismiss();
 
                                   }
 
                }); 
 
         Spinner freestSpinner=(Spinner)freesDialog.findViewById(R.id.spinnerfrees);
 
         ArrayAdapter<CharSequence> freestadapter = ArrayAdapter.createFromResource(
 
                            this, R.array.frees, android.R.layout.simple_spinner_item);
 
        freestadapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
 
        freestSpinner.setAdapter(freestadapter);
Parsed in 0.038 seconds,  using GeSHi 1.0.8.4

Can i change that in this?

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

public void zoek()
 
{
 
         final Dialog freesDialog = new Dialog(this);
 
         freesDialog.setTitle("Gegevens");
 
         freesDialog.setContentView(R.layout.dialog);
 
         freesDialog.show();
 
         Button okbutton =(Button) freesDialog.findViewById(R.id.Ok);
 
         okbutton.setOnClickListener(new View.OnClickListener(){  
 
                public void onClick(View view) { 
 
                        freesDialog.dismiss();
 
                                   }
 
                });
 
                Spinner freestSpinner=(Spinner)freesDialog.findViewById(R.id.spinnerfrees);
 
                freestSpinner.setOnItemSelectedListener(new OnItemSelectedListener(){
 
                        @Override
 
                        public void onItemSelected(AdapterView parent, View v, int position, long id) {
 
                                ArrayAdapter<CharSequence> freestadapter = ArrayAdapter.createFromResource(
 
                                                this, R.array.frees, android.R.layout.simple_spinner_item);
 
                                freestadapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
 
                                freestSpinner.setAdapter(freestadapter);
 
                        }
 
                }); //  <-This gives my a error
Parsed in 0.039 seconds,  using GeSHi 1.0.8.4

I now there something wrong with this code but i ám newbe android.

Thanks in advance.

plusminus · by **plusminus** » Fri Feb 01, 2008 6:53 pm

Hello

your error is... right :?:

:

Cannot refer to a non-final variable freestSpinner inside an inner class defined in a different method

Just place freestSpinner as a class variable instead of using is as a local variable.

Regards,
plusminus

dragon · by **dragon** » Sat Feb 02, 2008 3:48 pm

Can you give me a litle example code.
Ihave still error's

Thaks in advance.

plusminus · by **plusminus** » Sat Feb 02, 2008 4:03 pm

Hello dragon,

i do not know your code, so how to help :?:

I also do not know what the error message is.

two post before I was speaking of sth like this:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

 
class YourClass{
 
private Spinner freestSpinner;
 
public void zoek(){
 
      final Dialog freesDialog = new Dialog(this);
 
      freesDialog.setTitle("Gegevens");
 
      freesDialog.setContentView(R.layout.dialog);
 
      freesDialog.show();
 
      Button okbutton =(Button) freesDialog.findViewById(R.id.Ok);
 
      okbutton.setOnClickListener(new View.OnClickListener(){  
 
               public void onClick(View view) {
 
                    freesDialog.dismiss();
 
                            }
 
               });
 
          freestSpinner=(Spinner)freesDialog.findViewById(R.id.spinnerfrees);
 
          freestSpinner.setOnItemSelectedListener(new OnItemSelectedListener(){
 
               @Override
 
               public void onItemSelected(AdapterView parent, View v, int position, long id) {
 
                    ArrayAdapter<CharSequence> freestadapter = ArrayAdapter.createFromResource(
 
                              this, R.array.frees, android.R.layout.simple_spinner_item);
 
                    freestadapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
 
                    freestSpinner.setAdapter(freestadapter);
 
               }
 
          });
Parsed in 0.041 seconds,  using GeSHi 1.0.8.4

without more information I cannot help further.

Regards,
plusminus

dragon · by **dragon** » Sat Feb 02, 2008 4:44 pm

Hello,

Here are the error's i have comment the errors.

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

class SpinnerBox{
 
                 private Spinner freestSpinner;
 
                 public void zoek(){
 
                       final Dialog freesDialog = new Dialog(this); // Give a error.
 
                       freesDialog.setTitle("Gegevens");
 
                       freesDialog.setContentView(R.layout.dialog);
 
                       freesDialog.show();
 
                       Button okbutton =(Button) freesDialog.findViewById(R.id.Ok);
 
                       okbutton.setOnClickListener(new View.OnClickListener(){  
 
                                public void onClick(View view) {
 
                                     freesDialog.dismiss();
 
                                             }
 
                                });
 
                           freestSpinner=(Spinner)freesDialog.findViewById(R.id.spinnerfrees);
 
                           freestSpinner.setOnItemSelectedListener(new OnItemSelectedListener(){ // Give a error.
 
                                @Override
 
                                public void onItemSelected(AdapterView parent, View v, int position, long id) {  // Give a error.
 
                                     ArrayAdapter<CharSequence> freestadapter = ArrayAdapter.createFromResource( // Give a error.
 
                                               this, R.array.frees, android.R.layout.simple_spinner_item);
 
                                     freestadapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
 
                                     freestSpinner.setAdapter(freestadapter);
 
                                }
 
                           });
Parsed in 0.041 seconds,  using GeSHi 1.0.8.4

Thaks in advance.

plusminus · by **plusminus** » Sat Feb 02, 2008 10:30 pm

Hello dragon,

you need to be extending "Activity" (like JFrame in Swing).
Then you can use functions like findViewByID(...).

Every Activity look principally similar to this one:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

package org.anddev.android.Hello_Android;
 
import android.app.Activity;
import android.os.Bundle;
 
public class Hello_Android extends Activity {
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle icicle) {
        super.onCreate(icicle);
        // Make Android use the main.xml-layout-file.  
        this.setContentView(R.layout.main);
    }
}
Parsed in 0.037 seconds,  using GeSHi 1.0.8.4

If you want to create a Dialog-Style window like this one:

you need to create a normal Activity and add this line in onCreate:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

this.setTheme(android.R.style.Theme_Dialog); 
Parsed in 0.035 seconds,  using GeSHi 1.0.8.4

Regards,
plusminus

Database

Database

Who is online