Why not have a computed column such as:
FullName computed by LastName || ' ' || FirstName
Rich P...

-----Original Message-----
From: slsolutions2002 [mailto:strtline@...]
Sent: 18 February 2002 13:49
To: ib-support@yahoogroups.com
Subject: [ib-support] Trigger SQL


Hello:

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

Thanks Geno









To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/