Re: Field captions from MS Access
- From: "Peter Laman" <peter@xxxxxxxx>
- Date: Fri, 17 Feb 2006 12:33:58 +0100
I know that one. Unfortunately it returns the description and not the
"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
MS Access offers the possibility to specify a caption for each field in
Isfield definition. I'm writing a Delphi program that accesses an MS Access
database through ADO. I'd like to assing the captions as definied in the
database to the DisplayLabel property of the TField components in Delphi.
codethere a way to do it? I Already tried Fields.Properties (from ADO) andIf you import the ADOX type library you can get at the description with
OpenSchema, but that doesn't give me the information. Any clues?
fCatalog : Catalog;
fCatalog := CoCatalog.Create;
Column := fCatalog.Tables['tablename'].Columns['columnname'];
strColProp := Column.Properties['Description'].Value;
Brian Bushay (TeamB)