When using a view in Servoy, it requires that you specify which column in the view is the primary key. In my tests so far it won’t let me tell it that a certain column is a pk - the closest I can get it to say it’s a row ident and that seems to work. Is that what I’m supposed to do?
Yep, that’s what my understanding is as well. It’s the same for views and tables: If they don’t hae a DB defined PK, you specify the rowidentifier(s) in Servoy.
Paul
Yes because a view by definition really doesn’t have a ‘primary key’. That is also why most SQL databases generally do not allow updating of rows via views. Using the ‘row identifier’ however allows Servoy to know which row you wish to display or ‘select’ from.