MFC添加数据insert语句出错

Question

代码中写了一条插入语句，如下：

strSql.Format(_T("INSERT INTO Bill_Info
(Bill_ID,Buyer_Name,Buyer_Book,Buyer_State,Price)
values（'%s','%s','s','%d','%f')"),
b.getbid(),b.getbname(),b.getbbook(),b.getbstate(),b.getprice());
调用 pRst->Update();时报错，加了断点发现
语句显示的是：

• strSql L"INSERT INTO Bill_Info (Bill_ID,Buyer_Name,Buyer_Book,Buyer_State,Price) values（'퀘\x18','癮污摩猠牴湩⁧潰楳楴湯촀췍췍췍췍﷽﷽ꮫꮫꮫꮫﻮﻮ','s','-858993460','-92559631349317831000000000000000000000000000000000000000000000.000000'... ATL::CStringT > > 请问，什么原因，怎么解决

Answer 1

 values（'%s','%s','%s','%d','%f') //少个%