>we have some workstations. Every ws need to show some fields of an table. >Now I thought, I can configure that with the numbers of the column. I also >could write >down the column-Names in a configuration table, but sql statements should be >slower.
No need for a configuration table, Olaf, you could construct your query on the fly from the system tables, e.g. WITH TMP(FieldName, FieldPos) AS (SELECT RDB$FIELD_NAME, RDB$FIELD_POSITION+1 FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME = :MyTableName ORDER BY RDB$FIELD_POSITION) SELECT 'SELECT ' || LIST(FieldName) || ' FROM ' || cast(:MyTableName as Char(31)) || ' WHERE ... ' FROM TMP WHERE FieldPos in (2, 3) /*If you want field number 2 and 3*/ The result will be the SQL you want. HTH, Set
