slsolutions2002 wrote:

>
> 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.
> Can someone tell me the proper SQL.
>

String concatenation is done with the || symbol.


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further