strInsert.Format("insert into hx_sale (id,btid,shopid,shopname,price,unit,scount,saletime,saleuser,waiter,saleby) values ('%f','%d','%s','%s','%f','%s','%f','%s','%s','%s','%s','%s')",f,m_btlist.GetCurSel()+1,m_ShopNumber,m_shopname,fprice,m_unit,fcount,strTime,strSy,strWaiter,strSaleby,strHand);
如果要分行,可以
"insert into hx_sale (id,btid,shopid,shopname,price,unit,scount,saletime,saleuser,waiter,saleby)"
"values ( '%f ', '%d ', '%s ', '%s ', '%f ', '%s ', '%f ', '%s ', '%s ', '%s ', '%s ', '%s ')"