求助！！急急急！在线等！[Microsoft][ODBC SQL Server Driver]COUNT 字段不正确或语法错误"

[vip270916387]

我用Qt 4.8.1操作MS SERVER 2005 在执行下面这语句时提示[Microsoft][ODBC SQL Server Driver]COUNT 字段不正确或语法错误"
下面是创建的表
create table tb_Purchase_Detail (
purchase_id character(15) not null,
commodity_id varchar(20) not null,
purchase_account smallint not null,
real_price money not null,
purchase_rebat real not null,
constraint PK_TB_PURCHASE_DETAIL primary key (purchase_id, commodity_id),
constraint FK_TB_PURCHASE foreign key (purchase_id) references tb_Purchase(purchase_id) on delete cascade,
constraint FK_TB_COMMODITY_INFO foreign key (commodity_id) references tb_Commodity_Info(commodity_id)
)
go

下面是在Qt平台上执行的语句
QString detail_sql = "INSERT INTO tb_Purchase_Detail ";
detail_sql += QString("VALUES(:purchase_id, :commodity_id, :purchase_account, :real_price, :purchase_rebat)");

QSqlQuery detailQuery;
detailQuery.prepare(detail_sql);

QString str1 = "CJ12051500061";
QString str2 = "250030";
query.bindValue(":purchase_id", str1);
query.bindValue(":commodity_id", str2);
query.bindValue(":purchase_account", 3);
query.bindValue(":real_price", 2);
query.bindValue(":purchase_rebat", 0.9);

detailQuery.exec();

[vip270916387]

我擦，自己发现问题了！ query.bindValue绑定手误了，应该是用detailQuery来绑定值的

[shen_wei]

来学习。。。手写要仔细！！！