Subject Re: [firebird-support] Retrieving field new and old value using variable
Author Alexandre Benson Smith
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.


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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil