无法在sqlite中找到列

你在CREATE TABLE语句中遗漏了一些逗号,这意味着它们将被视为一列而不是分开.

String CREATE_ALERT_TABLE = "CREATE TABLE " + Constants.TABLE_NAME + "("
                + Constants.KEY_ID + " INTEGER PRIMARY KEY,"
                + Constants.KEY_PARTY_NAME + "TEXT,"
                + Constants.KEY_CHEQUE_NUMBER + "TEXT"  // <-- HERE
                + Constants.KEY_AMOUNT + "TEXT"         // <-- HERE
                + Constants.KEY_EXPIRY_DATE + "LONG"    // <-- HERE
                + Constants.KEY_REMINDER_DATE + "LONG"  // <-- HERE
                + Constants.KEY_REMINDER + "Text,"
                + Constants.KEY_BANK_NAME + "TEXT);";  

您还在列类型之前缺少空格,因此例如reminder列将显示reminderText在构造语句中.我建议你重新格式化你的CREATE TABLE陈述:

String CREATE_ALERT_TABLE = "CREATE TABLE " + Constants.TABLE_NAME + " ("
                + Constants.KEY_ID + " INTEGER PRIMARY KEY,"
                + Constants.KEY_PARTY_NAME + " TEXT,"
                + Constants.KEY_CHEQUE_NUMBER + " TEXT,"
                + Constants.KEY_AMOUNT + " TEXT,"
                + Constants.KEY_EXPIRY_DATE + " LONG,"
                + Constants.KEY_REMINDER_DATE + " LONG,"
                + Constants.KEY_REMINDER + " TEXT,"
                + Constants.KEY_BANK_NAME + " TEXT);";  

您需要添加的另一个空间是ORDER BY此查询的一部分:

Constants.KEY_ID + "DESC"

需要是:

Constants.KEY_ID + " DESC"