在准备"创建表Project_Details时，在0x1f1700上插入失败 1(接近 "0"：语法错误)时，im 收到错误

Question

public void onCreate(SQLiteDatabase db) {
    // TODO Auto-generated method stub
    String ProjectDetailTable = "CREATE TABLE " + TABLE_PROJECT_DETAIL  + "("
            + ProjectID  + " INTEGER PRIMARY KEY AUTOINCREMENT," + ProjectName + " VARCHAR," + Budget + " VARCHAR," + Duration + " VARCHAR," + StartDate+ " VARCHAR," + ProjectDescription+ " VARCHAR)";
    String ExpensesTable = " CREATE TABLE " + TABLE_PROJECT_EXPENSES + "("+ExpensesID+"INTEGER PRIMARY KEY AUTOINCREMENT,"+ExpProjectName+"VARCHAR," 
                +Date +"VARCHAR,"+ExpensesTitle+"VARCHAR,"+ExpensesAmount+"VARCHAR,"+ExpDescription+"VARCHAR)";
      db.execSQL(ProjectDetailTable);
      db.execSQL(ExpensesTable);

}

Answer 1

在Column Name和Column Type 之间添加空格

 String ExpensesTable = " CREATE TABLE " + TABLE_PROJECT_EXPENSES + "("+ExpensesID+" INTEGER PRIMARY KEY AUTOINCREMENT,"+ExpProjectName+" VARCHAR," 
            +Date +" VARCHAR,"+ExpensesTitle+" VARCHAR,"+ExpensesAmount+" VARCHAR,"+ExpDescription+" VARCHAR)";

Answer 2

在第二个查询中添加字段名称和字段类型之间的空格。

String ExpensesTable = " CREATE TABLE " + TABLE_PROJECT_EXPENSES + " ( "+ExpensesID+" INTEGER PRIMARY KEY AUTOINCREMENT,"+ExpProjectName+" VARCHAR," 
                +Date +" VARCHAR,"+ExpensesTitle+" VARCHAR,"+ExpensesAmount+" VARCHAR,"+ExpDescription+" VARCHAR)";