You call

adapter=new DatabaseAdapter( this, R.layout.listrow, listResults);

instead of

adapter=new ArrayAdapter<String>( this,android.R.layout.simple_list_item_1,results);

That error must be a syntax error, or try Menu > project > CLEAN

If you can't get your implementation to work please start again with the orject class's I sent you as these are nice an clean and working!

I got it to show the list!! THANK YOU SO VERY MUCH FOR YOUR HELP!!!

Now I need to get the ID from the list,

can you please toss me one more couple lines of code?

I know how to get the click and get to the sub that handles it.

I might be able to figure this one

You can get the ID easily, have a look at the onClickListener that in the project I sent you

Code: Select all

@Override
   public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
      System.out.println("You have pressed ID: "+results.get(position).getId()+" Desc: "+results.get(position).getDescription());
   }


Is there some quick way to add functions like the OnItemClick or do you just have to know the syntax?

if you write that your class implements OnClickListener, your class name will get a red underline and you can click 'add unimplemented methods'. But these come like this:

public void onItemClick(AdapterView<?> arg1, View arg1, int arg3, long arg4) {

so to get the correct method paramater names you jsut put "android onItemClick" into google find the API and copy an past it from there

onItemClick(AdapterView<?> parent, View view, int position, long id)

Thanks again... I dont know how to say thank you enough. I would have been here for days trying to figure this out!

Seems like I need a class for every table I am working with, does that sound right?

How about the DatabaseAdapter class. Can I pass MyObj to the class so I can use the same class for the other tables?

Yeah if you make an object that's generic enough, that your happy with you can use one for all of them, or one for two and two others or one for each that's the joy of OO programming.

Just try to give all your class's sensible names, that relate to what they are there for and what they do. It gives you a reminder and helps with your organisation as well.

OK I have my list up and I can click and get the ID. Now I open another class that displays the details of the record, but I need to pass the ID to the new class. I think what I have below is 2 instances of the class, one is the re that I declared and another one when the startActivity happens. I need the ID to go too the class before the class opens so it knows what record # to display

You shouldnt use shorthand variable names like re and rec, it will confuse you when you come back later and confuses those who help you this is a new topic, pls start a new thread. This time in the right category!

Lol, that attachment I uploaded, did it make any sense?! I think I uploaded the wrong file! I'll upload the correct one tonight!

HAHA! I was trying to understand why it didnt seem to relate to the discussion at all I put it on the side as I thought I just didnt know enough yet!

On the code below,
public class DatabaseAdapter extends ArrayAdapter<Grp>

I can see that I pass the results to this class in the 3rd parameter, but the declaration has <Grp> when doesnt seem to be a generic ArrayList. So even though I pass results why does the declaration have GRP?

Because the declaration is basically saying 'this is going to be an ArrayList with the Type Grp inside it'.

Ha glad you got it working, it'll be so much clearer when I upload the project

But the type grp class can be different for different tables in the DB. If I always arrange for an ID and DESCRIPTION then that makes sense, but what happens if they are not those fields. So if I pass a results that has a different structure than grp does, will that still work?

Ah I see, try

private ArrayList<?> mItems;

Ha! I was guessing that is what I needed SO the ? is like a wild card?