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?

Adam


You need to query the information  tables

SELECT Description FROM information.TableColumns WHERE TableName = 'xxx' AND Name = 'yyy'

Roy Lambert [Team Elevate]

Brilliant Roy, thanks!