easyindian
Posts: 10
|
Posted: 12/26/2006, 7:19 AM |
|
Dear Bros,
Read my signature first
I have table like this
And a trigger like this
************************
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Employee_FullName]
ON [dbo].[Employees]
FOR DELETE , INSERT , UPDATE
AS
DECLARE @EmployeeID real
DECLARE @FullName char(30)
SELECT @EmployeeID = (SELECT DepartmentCode + '-' + EmployeeNo FROM Inserted)
SELECT @FullName = (SELECT FirstName+''+MiddleName+''+LastName FROM Inserted)
INSERT INTO dbo.Employees(EmployeeID, FullName)
VALUES ('@EmployeeID','@FullName')
*****************************************
I created a record page using the builder. ran the app. result is:
[/IMG]
Please help me
I must enter '001' in department code and 0xx in employee no
please help....
_________________
I am a No-No in development |
|
|
|