本人小白一个,做学校布置的大作业时遇到这样一个问题:
query.prepare("INSERT INTO Orders(Name,Quantity,Weight,G_Type,Destination,Applicant,S_Date)"
"VALUES(:name,:quantity,:weight,:type,:destination,:applicant,:date)");
query.bindValue(":name",ui->NameEdit->text());
query.bindValue(":quantity",ui->quanEdit->value());
query.bindValue(":weight",ui->WeigEdit->value());
query.bindValue(":type",ui->TypeEdit->text());
query.bindValue(":destination",ui->DestinEdit->text());
query.bindValue(":applicant",Applicant);
query.bindValue(":date",QDate::currentDate().toString("yyyy-mm-dd"));
query.exec();
结果报错:QODBCResult::exec: Unable to execute statement: "[Microsoft][ODBC SQL Server Driver][SQL Server]从字符串转换日期和/或时间时,转换失败。"
实在不知道该怎么办,求大神解答。