CDaoDatabase db;
db.Open(_T("db.mdb"));
CDaoTableDef td(&db);
// Replace the line above with the following code to fix the problem:
// #if _MFC_VER < 0x0421
// CNewDaoTableDef td(&db); // need to use new class w/ VC++ 4.2x
// #else
// CDaoTableDef td(&db); // building with VC++ 5.0 the bug doesn't
// exist #endif
td.Create(_T("FieldTest"));
CDaoFieldInfo fi;
fi.m_strName = _T("testfield");
fi.m_nType = dbText;
fi.m_lSize = 50;
fi.m_lAttributes = dbFixedField;
fi.m_nOrdinalPosition = 0;
fi.m_bRequired = FALSE;
fi.m_bAllowZeroLength = TRUE;
fi.m_lCollatingOrder = dbSortGeneral ;
fi.m_strDefaultValue = _T("default value");
td.CreateField(fi);
td.Append();
CDaoRecordset rs(&db);
rs.Open(dbOpenDynaset, _T("Select * from FieldTest"));
rs.AddNew();
rs.Update();
rs.Close();
db.Close();
一个使用CDaoTableDef::CreateField()的例子
最新推荐文章于 2021-03-18 02:27:56 发布