Re: Field captions from MS Access
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Thu, 16 Feb 2006 22:23:34 -0600
MS Access offers the possibility to specify a caption for each field in theIf you import the ADOX type library you can get at the description with code
field 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. Is
there a way to do it? I Already tried Fields.Properties (from ADO) and
OpenSchema, but that doesn't give me the information. Any clues?
like this
Use ADOX:
var
Column: _Column;
fCatalog : Catalog;
begin
fCatalog := CoCatalog.Create;
fCatalog._Set_ActiveConnection(ADOConnection.ConnectionString);
Column := fCatalog.Tables['tablename'].Columns['columnname'];
strColProp := Column.Properties['Description'].Value;
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- Follow-Ups:
- Re: Field captions from MS Access
- From: Peter Laman
- Re: Field captions from MS Access
- References:
- Field captions from MS Access
- From: Peter Laman
- Field captions from MS Access
- Prev by Date: Re: ADO and MDAC issues on XP systems
- Next by Date: Re: ADO with paradox
- Previous by thread: Field captions from MS Access
- Next by thread: Re: Field captions from MS Access
- Index(es):
Relevant Pages
|
