if(m_stuset.GetRecordCount()==0)
{
sql.Format( _T( "insert into training_stu values ( %d,%s,%s,%s,%s,%s,%s)"),
i,
m_stu_name2,
m_stu_sex2,
m_stu_age2,
m_stu_card_no2,
m_stu_address2,
m_stu_tel2);
m_database.ExecuteSQL(sql);
m_database.Close();
一运行就提示关闭程序,format用法有错吗?m_stu_name2等是编辑框关联变量。感激不尽啊!!!!!!!
{
sql.Format( _T( "insert into training_stu values ( %d,%s,%s,%s,%s,%s,%s)"),
i,
m_stu_name2,
m_stu_sex2,
m_stu_age2,
m_stu_card_no2,
m_stu_address2,
m_stu_tel2);
m_database.ExecuteSQL(sql);
m_database.Close();
一运行就提示关闭程序,format用法有错吗?m_stu_name2等是编辑框关联变量。感激不尽啊!!!!!!!
insert into table1(字段列表) values(‘val1’,’val2‘)values后面的的value值如果是字符串类型,要用单引号括起来。如果字段是整型,也可以在sql语句里用单引号括起来,会自动类型转换。