sqlite - 我如何解决sqlite数据库E/SQLiteLog(16449)中的此类错误: “Order”附近的(1):语法错误

Question

我正在尝试创建另一个到sqlite数据库的表，以从json链接插入新数据，突然我叠了这种错误，我已经在卸载和安装了我的应用程序，任何建议将不胜感激。
这是我的db dart文件。

//Creating Table and opening of my db
initDB() async {
      String path = join(await getDatabasesPath(), 'dbdev.db');
      return await openDatabase(path, version: 1, onOpen: (db) {
      },onCreate: (Database db, int version) async {
        await db.execute(
        "CREATE TABLE sku_table("
        "Id INTEGER PRIMARY KEY AUTOINCREMENT,"
        "ShortCode TEXT NULL,"
        "CampaignShortCode TEXT NULL,"
        "Code TEXT NULL,"
        "Name TEXT NULL,"
        "IsActive BOOL NULL,"
        "GenericName TEXT NULL,"
        "Level INTEGER NULL);",
      );
          //here where my error is
      await db.execute(
        "CREATE TABLE RegisterTabs("
          "RegId INTEGER PRIMARY KEY AUTOINCREMENT,"
          "SortOrder INTEGER NULL,"
          "CampaignShortCode TEXT NULL,"
          "Order INTEGER NULL,"
          "ItemList TEXT NULL,"
          "Note TEXT NULL,"
          "IsActive BOOL NULL,"
          "IsRequired BOOL NULL,"
          "Label TEXT NULL,"
          "Key TEXT NULL,"
          "Tag TEXT NULL,"
          "InputType TEXT NULL,"
          "MaxLength INTEGER NULL,"
          "MinLength INTEGER NULL,"
          "Hint TEXT NULL,"
        "Delimiter TEXT NULL);",
      );
    }
      );
  }

Answer 1

Order是sqlite keyword。将列重命名为其他名称(例如OrderNo)是最简单的。