TechVale - Gustavo wrote:

> Hi All,
>
> May i retrieve the "new" and "old" field values using its field name in a trigger ?
>
> i would like to do something like :
>
> for select <SelectToGetAllFieldsNameInTable> into :MyFieldName do
> begin
> if( <OldFieldNameUsingMyFieldNameVar> <> <NewFieldNameUsingMyFieldNameVar> ) then ...
>
> Thanks in advanced,
>
> Gustavo.
>

Gustavo,

You could go the EXECUTE STATEMENT way.

But I would create a simple app that reads the RDB$Relations,
RDB$Relation_Fields, etc. and generate a script with the full SQL

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br