diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index 70e97a8..f62915b 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -957,7 +957,7 @@ { QSqlQuery query; query.prepare("INSERT INTO zd_communication_setting (id,device_id,communication_type,serial_port,visa,create_time,update_time) " - " VALUES (':id',':device_id',':communication_type',':serial_port',':visa',':create_time',':update_time')"); + " VALUES (:id,:device_id,:communication_type,:serial_port,:visa,:create_time,:update_time)"); QString formattedDateTime = configInterdace.create_time.toString("yyyy-MM-dd HH:mm:ss"); QString formattedUpdateDateTime = configInterdace.update_time.toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":id", configInterdace.id); @@ -1034,7 +1034,7 @@ { QSqlQuery query; query.prepare("INSERT INTO zd_instruction_library (id,device_id,device_name,instruct_config,instruct_read,type,verification_id,check_id,create_time,update_time) " - " VALUES (':id',':device_id',':device_name',':instruct_config',':instruct_read',':type',':belong_vername',':belong_checkname',':create_time',':update_time')"); + " VALUES (:id,:device_id,:device_name,:instruct_config,:instruct_read,:type,:belong_vername,:belong_checkname,:create_time,:update_time)"); query.bindValue(":id", instructionLib.id); query.bindValue(":device_id", instructionLib.device_id);