Sign in | Join
Last post 07-04-2009 11:39 AM by drtrejos. 2 replies.
Sort Posts: Oldest to newest Newest to oldest
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
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.
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 !!