android.database.sqlite.SQLiteException: no such column: T.STATE_ID (code 1):

120 views
Skip to first unread message

raja mishra

unread,
Mar 2, 2016, 12:51:23 AM3/2/16
to greenDAO
public static List<String> getStates(Context ctx) {

List<String> allStates = new ArrayList<>();
String sql = "SELECT stateName FROM (SELECT stateName, COUNT(stateName) as count from Branch GROUP BY stateName) WHERE count = 1";
Cursor c = Manager.getDb(ctx).rawQuery(sql, null);
c.moveToFirst();
while (!c.isAfterLast()) {
String stateName = c.getString(0);
allStates.add(stateName);
c.moveToNext();
}
c.close();
return allStates;
}

raja mishra

unread,
Mar 2, 2016, 12:52:43 AM3/2/16
to greenDAO
Entity branch = schema.addEntity("Branch");
branch.setTableName("branch");
branch.addIdProperty();
branch.addStringProperty("stateId");
branch.addStringProperty("stateName");
branch.addStringProperty("cityId");
branch.addStringProperty("city");
branch.addStringProperty("brlocflag");
branch.addStringProperty("landlineno1");
branch.addStringProperty("pincode");
branch.addStringProperty("branchadd1");
branch.addStringProperty("branchadd2");
branch.addStringProperty("lat");
branch.addStringProperty("_long");
branch.addStringProperty("branchid");
branch.addStringProperty("weekdays");
branch.addStringProperty("saturday");

new DaoGenerator().generateAll(schema, "../HDFC/app/src/main/java/");

Why this error ??
Reply all
Reply to author
Forward
0 new messages