K
Kaushik
Hi,
My problem is that --
I have to use a view as a record source in one .ADP project.As the view is
joining more than two tables I had to create an 'Instead Of Trigger' in the
SQL server end for allowing a table used in the view to be updated.
When I run the view from SQL server end updation is happening fine but
from the Access from when ever I am trying to update a record -- recordset
not updatable error is showig.
I have also tried by checking the View proporties "Updatable By Rules" but
same result is coming.
Here is the code of the View
CREATE VIEW dbo.testmain4
WITH VIEW_METADATA
AS
SELECT *,(SELECT MIN(date) FROM notes WHERE id = notes.id) AS
NoteDate
FROM dbo.Main
and the trigger is
CREATE TRIGGER triTestmain4 ON testmain4
INSTEAD OF UPDATE
AS
BEGIN
SET NOCOUNT ON
UPDATE main
SET
--EmployeeID = I.EmployeeID,
--Department = I.Department,
Volunteer = I.Volunteer
FROM testmain4 E, inserted I
WHERE E.ID = I.ID
END
Can Any body give a clue??]
Thanks
My problem is that --
I have to use a view as a record source in one .ADP project.As the view is
joining more than two tables I had to create an 'Instead Of Trigger' in the
SQL server end for allowing a table used in the view to be updated.
When I run the view from SQL server end updation is happening fine but
from the Access from when ever I am trying to update a record -- recordset
not updatable error is showig.
I have also tried by checking the View proporties "Updatable By Rules" but
same result is coming.
Here is the code of the View
CREATE VIEW dbo.testmain4
WITH VIEW_METADATA
AS
SELECT *,(SELECT MIN(date) FROM notes WHERE id = notes.id) AS
NoteDate
FROM dbo.Main
and the trigger is
CREATE TRIGGER triTestmain4 ON testmain4
INSTEAD OF UPDATE
AS
BEGIN
SET NOCOUNT ON
UPDATE main
SET
--EmployeeID = I.EmployeeID,
--Department = I.Department,
Volunteer = I.Volunteer
FROM testmain4 E, inserted I
WHERE E.ID = I.ID
END
Can Any body give a clue??]
Thanks