insert into 问题,写一条新记录到数据库!在线等!!!
前期工作已经做了
#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")
AfxOleInit();
m_pConnection.CreateInstance("ADODB.Connection");///创建Connection对象
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=customer.mdb","","",adModeUnknown);///连接数据库
//把对话框中ID号为IDC_NumberPlate,IDC_VehicleID1,IDC_VehicleType,IDC_Color(四个Edit Contrlo控件)写入到表car中四个字段NumberPlate,VehicleID1,VehicleType, Color中。
_variant_t RecordsAffected;
m_pConnection->Execute("insert into car (NumberPlate,VehicleID1,VehicleType,Color)\
values (IDC_NumberPlate,IDC_VehicleID1,IDC_VehicleType,IDC_Color)",\
编译通过
运行出现异常!!!
&RecordsAffected,adCmdText);