来自:hbezwwl, 时间:2002-6-22 19:59:00, ID:1177463 要用DAO对象,uses comobj;function TForm1.GetFiledDescript(FieldName: string): string; var DbEng: variant; TblDef: variant; DAOFld: Variant; Db: variant; i, j, k: integer; begin result := ''; try DbEng := CreateOleObject('DAO.DBEngine.36'); TblDef := CreateOleObject('DAO.TableDef.36'); DAOFld := CreateOleObject('DAO.Field.36'); db := dbeng.OpenDatabase('db1.mdb'); // ACCESS文件 for i := 0 to db.TableDefs.Count - 1 do begin TblDef := db.TableDefs[i]; for j := 0 to TblDef.Fields.Count - 1 do begin DAOFld := TblDef.Fields[j]; if DAOFld.Name = FieldName then // 在这里还可以加上对表的判断等 for k := 0 to DAOFld.Properties.Count - 1 do if DAOFld.Properties[k].Name = 'Description' then begin result := DAOFld.Properties[k].Value; exit; end; end; end; finally DAOFld := unassigned; TblDef := unassigned; DbEng := Unassigned; end; end;
adotable1.fields[i].fieldname
刚才没说明白
http://www.delphibbs.com/delphibbs/dispq.asp?lid=1261643
分类:数据库-C/S型 ( 版主:千中元, luyear )
来自:gaoronghui, 时间:2002-6-21 13:25:00, ID:1175753 [显示:小字体 | 大字体]
比如建立ACCESS数据表时,通常在每一项后面加上字段说明,方便以后查看。
但在DELPHI中。怎样才能提取到这些说明呢。
已经有了这类型的软件。
数据库文档生成器
http://cloud.prohosting.com/ccxx/
来自:gaoronghui, 时间:2002-6-22 19:39:00, ID:1177449
难道真的没办法吗?
不过别人可已经做到了!
来自:hbezwwl, 时间:2002-6-22 19:59:00, ID:1177463
要用DAO对象,uses comobj;function TForm1.GetFiledDescript(FieldName: string): string;
var
DbEng: variant;
TblDef: variant;
DAOFld: Variant;
Db: variant;
i, j, k: integer;
begin
result := '';
try
DbEng := CreateOleObject('DAO.DBEngine.36');
TblDef := CreateOleObject('DAO.TableDef.36');
DAOFld := CreateOleObject('DAO.Field.36'); db := dbeng.OpenDatabase('db1.mdb'); // ACCESS文件 for i := 0 to db.TableDefs.Count - 1 do
begin
TblDef := db.TableDefs[i];
for j := 0 to TblDef.Fields.Count - 1 do
begin
DAOFld := TblDef.Fields[j];
if DAOFld.Name = FieldName then // 在这里还可以加上对表的判断等
for k := 0 to DAOFld.Properties.Count - 1 do
if DAOFld.Properties[k].Name = 'Description' then
begin
result := DAOFld.Properties[k].Value;
exit;
end;
end;
end;
finally
DAOFld := unassigned;
TblDef := unassigned;
DbEng := Unassigned;
end;
end;
来自:gaoronghui, 时间:2002-6-24 12:50:00, ID:1179413
谢谢!hbezwwl
你可帮上大忙了。