Hi,

> I am using Interbase. I am tring to create a trigger that will take a
> customers first and last names and combine them as follows:
>
> Set Term !! ;
> Create Trigger tgUpdateFullName For Customers
> After Update
> Position 0
> As
> Begin
> New.FullName = New.LastName + ' ' + New.FirstName;
> End !!
> Set Term ; !!
> Commit;
>
> I get an error message that tells me the calculation is sunsupported.

I have no idea what 'Martijn' + 'Tonies' would be - how does this add up? :)

> Can someone tell me the proper SQL.

The documentation says: || (double pipe)

Martijn Tonies
New version available! Download your trial copy of
InterBase Workbench - the developer tool for InterBase and Firebird
at http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."