Android Question Showing 2 differnt listviews with 2 differnt fields from the same Record.

[grant1842]

I have a table (Radio)
feilds are
Radio Text
TypeOfMod Text
PartsNeeded Text
ModInstructions
Ok on my main layout i am loading all the records in a listview 1

SQL.Initialize(File.DirDefaultExternal,"cb.db",True)
    DBUtils.CopyDBFromAssets("cb.db")
    DBUtils.ExecuteListView(SQL,"Select Radio.* From Radio",Null ,0,ListView1,False)

On my second activity I need to load (Listview111) only with the Field ( ModInstructions) that matchs the item I click on in the Main view(listview1).
Second listvew111 might be someing like this.

SQL.Initialize(File.DirDefaultExternal,"cb.db",True)
    DBUtils.CopyDBFromAssets("cb.db")
    DBUtils.ExecuteListView(SQL,"Select ModInstructions From Radio",Null ,0,ListView111,False)

I just need it to show only the record i click on listview1.

Can someone point me in the right direction .
Thanks

 

[Erel]

You should only copy the database one and initialize SQL once.

You can use CallSubDelayed to start the second activity and pass the information needed for the second query.