I have datasource based on a view with instead of update trigger(it works) and an artificial primary key is built. But DML checkboxes are gray settings and dropdown list contains only "None". Yes, the view contains"group by" clause. Can I use this view as a datasource of a grid to update data (using the trigger)? Thanks, Inna.

asked 01 Feb '16, 03:25

Inna's gravatar image

accept rate: 0%

Hi Inna,

It seems like your Datasorce Definition is missing a mandatory column. This is why you don't see any candidates for primary key in your combobox. No problem though. All you need to do is to mark a column as mandatory so that if can show up in the Primary Key combobox.

To make a column mandatory select the column under the columns node, in the navigation panel on the left of the Datasource Definition Dialog. The go back to the main screen of the Dialog. The column you made mandatory will show up in the Primary Key combobox. Finally, do not forget to check one or more of the Insert, Update, Delete checkboxes depending on which operations you want to enable.

Hope this helps.

Kind Regards


answered 01 Feb '16, 05:37

Yalim's gravatar image

Yalim ♦♦
accept rate: 20%

Thanks a lot, Yalim. It works.


answered 01 Feb '16, 07:08

Inna's gravatar image

accept rate: 0%

Cool! Happy to help Inna!

(01 Feb '16, 11:41) Yalim ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 01 Feb '16, 03:25

Seen: 2,046 times

Last updated: 01 Feb '16, 11:41

© Copyright Gerger 2017