怎样读出ACESS数据库里面的表字段的类型、字段长度、字段备注内容？

[hchxxzx]

怎样读出ACESS数据库里面的表字段的类型、字段长度、字段备注内容？

[hchxxzx]

不会吧，居然没有人会？

[ehom]

字段类型rs("***").Type
字段长度rs("***").DefinedSize
字段备注内容是什么?:)

[ksy]

typename()

[dust3k]

Field Object
Represents a column of data with a common data type.






Remarks
Each Field object corresponds to a column in the Recordset. You use the Value property of Field objects to set or return data for the current record. Depending on the functionality the provider exposes, some collections, methods, or properties of a Field object may not be available.

With the collections, methods, and properties of a Field object, you can do the following:

Return the name of a field with the Name property.
View or change the data in the field with the Value property. Value is the default property of the Field object.
Return the basic characteristics of a field with the Type, Precision, and NumericScale properties.
Return the declared size of a field with the DefinedSize property.
Return the actual size of the data in a given field with the ActualSize property.
Determine what types of functionality are supported for a given field with the Attributes property and Properties collection.
Manipulate the values of fields containing long binary or long character data with the AppendChunk and GetChunk methods.
If the provider supports batch updates, resolve discrepancies in field values during batch updating with the OriginalValue and UnderlyingValue properties.
All of the metadata properties (Name, Type, DefinedSize, Precision, and NumericScale) are available before opening the Field object's Recordset. Setting them at that time is useful for dynamically constructing forms.

[dust3k]

字段备注内容是什么?:) --> the content of Memo type field

[hchxxzx]

ksy(我是菜鸟我怕谁!我就是来送分的.)
不行，根本不接受这个
Microsoft VBScript 运行时错误 错误 '800a01b6'

对象不支持此属性或方法: 'typename'

[hchxxzx]

dust3k(尘) :实在高明。
字段备注内容是什么?:) 这个可能是我写错了，我的原意是每个字段后面的说明文字，不知有没有办法得到？
为表示敬意，此贴再加分

[julyclyde]

typename不是方法，是VBScript函数

[ehom]

对,和用rs("***").Type效果类似,用来返回数据类型!

[ehom]

我认为用ADO读不出来,自己编写数据库接口?
上面的方法其实是用了ADO的FIELD对象属性!而FIELD对象属性中没有字段后面的说明文字这项!而且是否每种数据库都有字段备注这项内容?

[hchxxzx]

就我所知，ORCALE就可以读出来，但ACESS我不知道。但我想每种数据库应都有这种东西吧，否则设计时不就很麻烦？

[hchxxzx]

是不是大家的意思不同？我的意思是要取出数据库里面每个字段在设计时的功能说明文字，不是要得到读出的数据的类型。是不是这个问题很难或很难理解？大家看一下，如果能解决，请再来回答一下，不能解决我也准备给分了。