I want to pop a list view with 2 linked tables for this I have created the next sql:
public static Cursor ListViewTimeStudy(String passedReg) {
// TODO Auto-generated method stub
String sql = "SELECT "
+ "elements._id,"
+ "elements.idstudy,"
+ "elements.code_element,"
+ "times._id,"
+ "times.idelement,"
+ "times.observedtime,"
+ "times.observedactivity"
+ " FROM "
+ "elements JOIN times"
+ " ON "
+ "elements._id = times.idelement"
+ " WHERE "
+ "elements.idstudy = passedReg"
+ " ORDER BY "
+ "times._id DESC";
Cursor mCursor = ourDatabase.rawQuery(sql, null);
if (mCursor != null) {
mCursor.moveToFirst();
}
return mCursor;
}
The result should show a table with fields from both tables and only the rows where elements.idstudy is equal to the variable passed in arguments of the function but in this issue I receive an error.
Aucun commentaire:
Enregistrer un commentaire