I am using the default dynamic data project. I've added one or two renderhints but other than that it is standard. I do not have any table-specific pages or controls in action here.
This is the script for the db that is having the problem:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Projects]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Projects](
[ProjectID] [int] IDENTITY(1,1) NOT NULL,
[ProjectName] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Projects] PRIMARY KEY CLUSTERED
(
[ProjectID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Statuses]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Statuses](
[StatusID] [int] IDENTITY(1,1) NOT NULL,
[StatusName] [nvarchar](50) NOT NULL,
[StatusLevel] [int] NOT NULL,
CONSTRAINT [PK_Statuses] PRIMARY KEY CLUSTERED
(
[StatusID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Priorities]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Priorities](
[PriorityID] [int] IDENTITY(1,1) NOT NULL,
[PriorityName] [nvarchar](50) NOT NULL,
[PriorityLevel] [int] NOT NULL,
CONSTRAINT [PK_Priorities] PRIMARY KEY CLUSTERED
(
[PriorityID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SecurityLevels]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SecurityLevels](
[SecurityLevelID] [int] IDENTITY(1,1) NOT NULL,
[SecurityLevelName] [nvarchar](50) NOT NULL,
[LevelValue] [int] NOT NULL,
CONSTRAINT [PK_SecurityLevels] PRIMARY KEY CLUSTERED
(
[SecurityLevelID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Notes]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Notes](
[NoteID] [int] IDENTITY(1,1) NOT NULL,
[IssueID] [int] NOT NULL,
[CreatedByID] [int] NOT NULL,
[NoteText] [nvarchar](4000) NOT NULL,
CONSTRAINT [PK_Notes] PRIMARY KEY CLUSTERED
(
[NoteID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Issues]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Issues](
[IssueID] [int] IDENTITY(1,1) NOT NULL,
[ProjectID] [int] NOT NULL,
[PriorityID] [int] NOT NULL,
[StatusID] [int] NOT NULL,
[CreatedByID] [int] NOT NULL,
[AssignedToID] [int] NULL,
[ResolvedByID] [int] NULL,
[IssueTitle] [nvarchar](50) NOT NULL,
[IssueDetails] [nvarchar](4000) NULL,
CONSTRAINT [PK_Issues] PRIMARY KEY CLUSTERED
(
[IssueID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Milestones]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Milestones](
[MilestoneID] [int] IDENTITY(1,1) NOT NULL,
[ProjectID] [int] NOT NULL,
[MilestoneName] [nvarchar](500) NOT NULL,
[DueDate] [datetime] NOT NULL,
CONSTRAINT [PK_Milestones] PRIMARY KEY CLUSTERED
(
[MilestoneID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Users]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Users](
[UserID] [int] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](50) NOT NULL,
[Password] [nvarchar](50) NOT NULL,
[SecurityLevelID] [int] NOT NULL,
CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Notes_Issues]') AND parent_object_id = OBJECT_ID(N'[dbo].[Notes]'))
ALTER TABLE [dbo].[Notes] WITH CHECK ADD CONSTRAINT [FK_Notes_Issues] FOREIGN KEY([IssueID])
REFERENCES [dbo].[Issues] ([IssueID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Notes_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[Notes]'))
ALTER TABLE [dbo].[Notes] WITH CHECK ADD CONSTRAINT [FK_Notes_Users] FOREIGN KEY([CreatedByID])
REFERENCES [dbo].[Users] ([UserID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Issues_Priorities]') AND parent_object_id = OBJECT_ID(N'[dbo].[Issues]'))
ALTER TABLE [dbo].[Issues] WITH CHECK ADD CONSTRAINT [FK_Issues_Priorities] FOREIGN KEY([PriorityID])
REFERENCES [dbo].[Priorities] ([PriorityID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Issues_Projects]') AND parent_object_id = OBJECT_ID(N'[dbo].[Issues]'))
ALTER TABLE [dbo].[Issues] WITH CHECK ADD CONSTRAINT [FK_Issues_Projects] FOREIGN KEY([ProjectID])
REFERENCES [dbo].[Projects] ([ProjectID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Issues_Statuses]') AND parent_object_id = OBJECT_ID(N'[dbo].[Issues]'))
ALTER TABLE [dbo].[Issues] WITH CHECK ADD CONSTRAINT [FK_Issues_Statuses] FOREIGN KEY([StatusID])
REFERENCES [dbo].[Statuses] ([StatusID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Table5_AssignedUsers]') AND parent_object_id = OBJECT_ID(N'[dbo].[Issues]'))
ALTER TABLE [dbo].[Issues] WITH CHECK ADD CONSTRAINT [FK_Table5_AssignedUsers] FOREIGN KEY([AssignedToID])
REFERENCES [dbo].[Users] ([UserID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Table5_CreateUsers]') AND parent_object_id = OBJECT_ID(N'[dbo].[Issues]'))
ALTER TABLE [dbo].[Issues] WITH CHECK ADD CONSTRAINT [FK_Table5_CreateUsers] FOREIGN KEY([CreatedByID])
REFERENCES [dbo].[Users] ([UserID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Table5_ResolvedUsers]') AND parent_object_id = OBJECT_ID(N'[dbo].[Issues]'))
ALTER TABLE [dbo].[Issues] WITH CHECK ADD CONSTRAINT [FK_Table5_ResolvedUsers] FOREIGN KEY([ResolvedByID])
REFERENCES [dbo].[Users] ([UserID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Milestones_Projects]') AND parent_object_id = OBJECT_ID(N'[dbo].[Milestones]'))
ALTER TABLE [dbo].[Milestones] WITH CHECK ADD CONSTRAINT [FK_Milestones_Projects] FOREIGN KEY([ProjectID])
REFERENCES [dbo].[Projects] ([ProjectID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Users_SecurityLevels]') AND parent_object_id = OBJECT_ID(N'[dbo].[Users]'))
ALTER TABLE [dbo].[Users] WITH CHECK ADD CONSTRAINT [FK_Users_SecurityLevels] FOREIGN KEY([SecurityLevelID])
REFERENCES [dbo].[SecurityLevels] ([SecurityLevelID])
ON UPDATE CASCADE
ON DELETE CASCADE
stevekain
Member
20 Points
16 Posts
Re: Dropdowns not updating correctly
Dec 19, 2007 03:44 PM|LINK
I am using the default dynamic data project. I've added one or two renderhints but other than that it is standard. I do not have any table-specific pages or controls in action here.
This is the script for the db that is having the problem: