Datasource builder advance options ghosted

Last post 07-04-2009 11:39 AM by drtrejos. 2 replies.

Sort Posts:

  • Datasource builder advance options ghosted

    07-03-2009, 2:47 AM
    • Member
      8 point Member
    • drtrejos
    • Member since 06-26-2009, 5:24 PM
    • Posts 39

    I am trying to make a datasource, for a MSSQL server table that has a two field's index. The advance options, to add insert and edit queries, is ghosted and therefore I can't add them.

    Any ideas why ?

    Humberto

  • Re: Datasource builder advance options ghosted

    07-04-2009, 8:44 AM
    Answer

    You either haven't set a Primary Key on the table you are selecting from, or you haven't included the PK column in the SELECT statement.  the wizard needs a PK to work out how to generate the additional commands.


    Regards Mike
    [MVP - ASP/ASP.NET]
    My site
  • Re: Datasource builder advance options ghosted

    07-04-2009, 11:39 AM
    • Member
      8 point Member
    • drtrejos
    • Member since 06-26-2009, 5:24 PM
    • Posts 39

    Mikesdotnetting:

    You either haven't set a Primary Key on the table you are selecting from, or you haven't included the PK column in the SELECT statement.  the wizard needs a PK to work out how to generate the additional commands.


    Thank You !!

Page 1 of 1 (3 items)