Hi
>
>SELECT RDB$DESCRIPTION FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME = :table_name ;
> AND RDB$FIELD_NAME = :field_name
>
Thanks.
>Actually, metadata info for fields are stored in 4 system tables: RDB@RELATIONS, RDB@RELATION_FIELDS, RDB$FIELDS and RDB$TYPES
>
>This command will gather info from all 4 system tables
This is great thanks a lot.
I had mentioned in my previous post that when I scan through the table builder cursor I am able to save desc. of the 1st field and not the 2nd. Well I added more fields and yet the thing works except for the 2nd field IPID, always. I have tried changing the table name. Yet got to try changing the field name IPID to something else.
Keep you posted and when there is something deliverable I can send you this copy of table builder if you like.