android - SQLite get row data using SELECT -
using sqlite database, have table 6 columns in each row rows added. first column name of "person." have when click on person in listview, brings screen 5 edit texts. fill them out , submit , adds row in database.
to retrieve data later on, trying use select name it, cannot figure out how works.
public cursor getchildrulesinformation(databaseoperations dop, string name) { dop.getreadabledatabase().execsql("select * "+child_rules_table_name+" "+child_name + "=\""+ name+"\""); }
what do retreive every column inside of specific row. confused on process out.
any lead in write direction appreciated. thanks. if need more information please let me know.
try this,
public cursor getchildrulesinformation(databaseoperations dop, string name) { return dop.getreadabledatabase().rawquery("select * "+child_rules_table_name+" "+child_name+" = '"+ name+"' ", null);}
Comments
Post a Comment