hallo Thomas,
Wenn ich die View im adp öffne, kann ich löschen.
Mache ich etwas falsch, oder geht das generell nicht?
Es geht nicht. Das kannst du ganz leicht prüfen, in dem du einen Datensatz im SSMS zu löschen versuchst.
Das es im ADP geht ist eher ein Feature vom ADP.
Hier ist mußt du eigentlich einen Trigger verwenden (ganz am Ende):
USE [test] ;
GO
SET ANSI_NULLS ON ;
GO
SET QUOTED_IDENTIFIER ON ;
GO
IF EXISTS ( SELECT *
FROM sys.triggers
WHERE object_id = OBJECT_ID(N'[dbo].[tr_AB_Del]') )
DROP TRIGGER [dbo].[tr_AB_Del] ;
GO
IF EXISTS ( SELECT *
FROM sys.views
WHERE object_id = OBJECT_ID(N'[dbo].[AB]') )
DROP VIEW [dbo].[AB] ;
GO
IF EXISTS ( SELECT *
FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[A]')
AND type IN ( N'U' ) )
DROP TABLE [dbo].[A] ;
GO
IF EXISTS ( SELECT *
FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[B]')
AND type IN ( N'U' ) )
DROP TABLE [dbo].[B] ;
GO
CREATE TABLE [dbo].[A]
(
[aID] [int] NOT NULL,
[aText] [varchar](255) NULL,
[aTS] [timestamp] NOT NULL,
[abID] [int] NULL,
PRIMARY KEY CLUSTERED ( [aID] ASC )
WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY]
)
ON [PRIMARY] ;
GO
CREATE TABLE [dbo].[B]
(
[bID] [int] NOT NULL,
[bText] [varchar](255) NULL,
[bTS] [timestamp] NOT NULL,
PRIMARY KEY CLUSTERED ( [bID] ASC )
WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY]
)
ON [PRIMARY] ;
GO
CREATE VIEW [dbo].[AB]
AS SELECT A.*,
B.*
FROM A
LEFT OUTER JOIN B ON A.abID = B.bID ;
GO
CREATE TRIGGER [dbo].[tr_AB_Del] ON [dbo].[AB]
INSTEAD OF DELETE
AS
SET NOCOUNT ON ;
DELETE FROM dbo.A
WHERE aID IN ( SELECT aID
FROM DELETED ) ;
GO
Microsoft MVP Office Access
https://mvp.support.microsoft.com/profile/Stefan.Hoffmann
