Subject | Trigger SQL |
---|---|
Author | slsolutions2002 |
Post date | 2002-02-18T13:48:36Z |
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
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