Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Accessing DESCRIPTION of FIELD from an application |
Tue, Jul 5 2011 6:42 AM | Permanent Link |
Adam Brett Orixa Systems | In EDB it is possible to define a column with a DESCRIPTION:
CREATE TABLE Test CREATE COLUMN "Test" VARCHAR(20) DESCRIPTION 'this is a test column' I would like to use the description and access it in my executable as a fly-over hint, to help users to understand the purpose of fields. However I can't see a way of retrieving it ... I had hoped it might exist as a property on the TFields member: Query.FieldByName('Test').Description //or similar. ... can I access it & how? |
Tue, Jul 5 2011 6:56 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
You need to query the information tables SELECT Description FROM information.TableColumns WHERE TableName = 'xxx' AND Name = 'yyy' Roy Lambert [Team Elevate] |
Tue, Jul 5 2011 9:26 AM | Permanent Link |
Adam Brett Orixa Systems | Brilliant Roy, thanks!
|
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |