for i=0 to count
{
...
m_Record.Query((“select * from mytable”));×××××
m_Database.BeginTrans();
m_Record.AddNew();
m_Record.SetField(_T("mcolumn"),sTemp );
m_Database.CommitTrans();
m_Database.Close(); 的一次循环就要出错!!! 为什么不能关闭
}
{
...
m_Record.Query((“select * from mytable”));×××××
m_Database.BeginTrans();
m_Record.AddNew();
m_Record.SetField(_T("mcolumn"),sTemp );
m_Database.CommitTrans();
m_Database.Close(); 的一次循环就要出错!!! 为什么不能关闭
}
sTemp是从SQLServer中得到的!
for i=0 to count
{
sTemp=m_SQLRecordset.Field(_T("mcolum"));
m_Record.Query((“select * from mytable”));×××××
m_Database.BeginTrans();
m_Record.AddNew();
m_Record.SetField(_T("mcolumn"),sTemp );
m_Database.CommitTrans();
m_Database.Close(); 的一次循环就要出错!!! 为什么不能关闭
}
for i=0 to count
{
sTemp=m_SQLRecordset.Field(_T("mcolum"));
m_Record.Query((“select * from mytable”));×××××
m_Database.BeginTrans();
m_Record.AddNew();
m_Record.SetField(_T("mcolumn"),sTemp );
m_Record.UpDate();!!!!!!
m_Database.CommitTrans();
m_Database.Close(); 的一次循环就要出错!!! 为什么不能关闭
}