颤振中不存在获取SQL语法错误列

sql语法如何在Flutter中工作?我收到一个错误消息,说一列不存在。

Exception has occurred.
SqfliteDatabaseException (DatabaseException(Error Domain=FMDatabase Code=1 "table addCashTable has no column named frequency" UserInfo={NSLocalizedDescription=table addCashTable has no column named frequency}) sql ' INSERT INTO addCashTable

这是我的SQL

  static Future<void> addAddCash(AddCash addCash) async {
    final sql = ''' INSERT INTO ${DatabaseCreator.addCashTable}
    (
      ${DatabaseCreator.id},${DatabaseCreator.name},${DatabaseCreator.amount},${DatabaseCreator.date},${DatabaseCreator.frequency},${DatabaseCreator.isDeleted}
    )
VALUES
    (
      \'${addCash.id}\',\'${addCash.name}\',\'${addCash.amount}\',\'${addCash.date}\',\'${addCash.frequency}\',\'${addCash.isDeleted ? 1 : 0}\'
    )''';
    final result = await db.rawInsert(sql);
    DatabaseCreator.databaseLog('Add Cash',sql,null,result);
  }
confessionscz 回答:颤振中不存在获取SQL语法错误列

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/3167860.html

大家都在问