> I Keep getting this error:
> Unsuccessful execution caused by a system error that precludes
> successful execution of subsequent statements.
> Dynamic SQL Error.
> expression evaluation not supported.
> Create trigger ..............................
> AS
>
> declare variable changes varchar(1000) ;
>
> begin
>
> changes = '';
>
> IF (old."id" <> new."id") THEN
> begin
> changes = :changes + 'ID: ' || old."id" || ' \ ' || new."id" || ', ';

changes + errr you have || elsewhere....
Alan

> end
>
> IF (old."nome" <> new."nome") THEN
> begin
> changes = :changes + 'NOME: ' || old."nome" || ' \ ' ||
> new."nome" || ', ';
> end
>
> if (:changes is not null) then
> begin
> INSERT into "HistoryTest"
> values
> (old."id", old."nome", 'now', 'U', :changes);
> end
> end
> Thanks
> Patrick
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>