locked
Edit Screen and Rendering of ComboBox Issue RRS feed

  • Question

  • User1630127833 posted

    Hello,
    I have created a Dynamic Data (LINQ) site and having an issue with rendering of the edit screens for one table.

    Below is my data structure and when FormItem table is being rendered in Edit mode, Zone ID field is being rendered as combo box however the possible values are not populated.
    Would there be a reason or this may be an issue in DDW?

     Relations

    Saturday, August 23, 2008 10:27 AM

All replies

  • User-797310475 posted

     I cannot really think why this situation would be any different. Could you post a minimal SQL schema that reproduces this problem?

    Saturday, August 23, 2008 5:02 PM
  • User1630127833 posted

    <p>

    Thanks for your interest in the issue marcind. 

    Not sure if the minimal schema will generate the same problem.

    below is the full db script.

     Thanks again.

    ----------------------

     

     

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Applications]') AND type in (N'U'))

    BEGIN

    CREATE TABLE [dbo].[Applications](

    [App_ID] [int] NOT NULL,

    [Name] [varchar](50) NOT NULL,

    [Status] [int] NULL,

    [Dt_Created] [datetime] NULL,

    [Dt_Modified] [datetime] NULL,

    [Created_By_ID] [int] NULL,

    [Modified_By_ID] [int] NULL,

    CONSTRAINT [PK_Applications] PRIMARY KEY CLUSTERED

    (

    [App_ID] 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].[Menus]') AND type in (N'U'))

    BEGIN

    CREATE TABLE [dbo].[Menus](

    [Menu_ID] [int] NOT NULL,

    [App_ID] [int] NOT NULL,

    [Name] [varchar](50) NULL,

     [varchar](50) NULL,

    [Type] [varchar](50) NULL,

    CONSTRAINT [PK_Menus] PRIMARY KEY CLUSTERED

    (

    [Menu_ID] 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].[Tabs]') AND type in (N'U'))

    BEGIN

    CREATE TABLE [dbo].[Tabs](

    [Tab_ID] [int] NOT NULL,

    [App_ID] [int] NULL,

    [Name] [varchar](50) NULL,

    [Title] [varchar](50) NULL,

    CONSTRAINT [PK_Tabs] PRIMARY KEY CLUSTERED

    (

    [Tab_ID] 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].[Forms]') AND type in (N'U'))

    BEGIN

    CREATE TABLE [dbo].[Forms](

    [Form_ID] [int] NOT NULL,

    [App_ID] [int] NULL,

    [Name] [varchar](50) NULL,

    [Style] [varchar](50) NULL,

    CONSTRAINT [PK_Forms] PRIMARY KEY CLUSTERED

    (

    [Form_ID] 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].[MenuItems]') AND type in (N'U'))

    BEGIN

    CREATE TABLE [dbo].[MenuItems](

    [MenuItem_ID] [int] NOT NULL,

    [Menu_ID] [int] NOT NULL,

    [Name] [varchar](50) NULL,

    [Text] [varchar](50) NULL,

    [Action] [varchar](255) NULL,

    [Help_Text] [varchar](255) NULL,

    [Parent_Menu_Item_ID] [int] NULL,

    CONSTRAINT [PK_MenuItems] PRIMARY KEY CLUSTERED

    (

    [MenuItem_ID] 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].[FormZones]') AND type in (N'U'))

    BEGIN

    CREATE TABLE [dbo].[FormZones](

    [Zone_ID] [int] NOT NULL,

    [Form_ID] [int] NULL,

    [Name] [varchar](50) NULL,

    [X_Pos] [int] NULL,

    [Y_Pos] [int] NULL,

    [Width] [int] NULL,

    [Height] [int] NULL,

    [Pos_Type] [varchar](50) NULL,

    [Style] [varchar](1024) NULL,

    CONSTRAINT [PK_FormZones] PRIMARY KEY CLUSTERED

    (

    [Zone_ID] 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].[FormItems]') AND type in (N'U'))

    BEGIN

    CREATE TABLE [dbo].[FormItems](

    [Form_ID] [int] NOT NULL,

    [Item_ID] [int] NOT NULL,

    [Item_Type] [int] NOT NULL,

    [Zone_ID] [int] NOT NULL,

    CONSTRAINT [PK_FormItems] PRIMARY KEY CLUSTERED

    (

    [Form_ID] ASC,

    [Item_ID] ASC,

    [Item_Type] 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_Menus_Applications]') AND parent_object_id = OBJECT_ID(N'[dbo].[Menus]'))

    ALTER TABLE [dbo].[Menus] WITH CHECK ADD CONSTRAINT [FK_Menus_Applications] FOREIGN KEY([App_ID])

    REFERENCES [dbo].[Applications] ([App_ID])

    GO

    IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tabs_Applications]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tabs]'))

    ALTER TABLE [dbo].[Tabs] WITH CHECK ADD CONSTRAINT [FK_Tabs_Applications] FOREIGN KEY([App_ID])

    REFERENCES [dbo].[Applications] ([App_ID])

    GO

    IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Forms_Applications]') AND parent_object_id = OBJECT_ID(N'[dbo].[Forms]'))

    ALTER TABLE [dbo].[Forms] WITH CHECK ADD CONSTRAINT [FK_Forms_Applications] FOREIGN KEY([App_ID])

    REFERENCES [dbo].[Applications] ([App_ID])

    GO

    IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_MenuItems_Menus]') AND parent_object_id = OBJECT_ID(N'[dbo].[MenuItems]'))

    ALTER TABLE [dbo].[MenuItems] WITH CHECK ADD CONSTRAINT [FK_MenuItems_Menus] FOREIGN KEY([Menu_ID])

    REFERENCES [dbo].[Menus] ([Menu_ID])

    GO

    IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FormZones_Forms]') AND parent_object_id = OBJECT_ID(N'[dbo].[FormZones]'))

    ALTER TABLE [dbo].[FormZones] WITH CHECK ADD CONSTRAINT [FK_FormZones_Forms] FOREIGN KEY([Form_ID])

    REFERENCES [dbo].[Forms] ([Form_ID])

    GO

    IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FormItems_Forms]') AND parent_object_id = OBJECT_ID(N'[dbo].[FormItems]'))

    ALTER TABLE [dbo].[FormItems] WITH CHECK ADD CONSTRAINT [FK_FormItems_Forms] FOREIGN KEY([Form_ID])

    REFERENCES [dbo].[Forms] ([Form_ID])

    GO

    IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FormItems_FormZones]') AND parent_object_id = OBJECT_ID(N'[dbo].[FormItems]'))

    ALTER TABLE [dbo].[FormItems] WITH CHECK ADD CONSTRAINT [FK_FormItems_FormZones] FOREIGN KEY([Zone_ID])

    REFERENCES [dbo].[FormZones] ([Zone_ID])

    </P>

    Saturday, August 23, 2008 10:03 PM