sql views and primary keys

Classic Servoy
1

I’m trying to use a view as the reference “table” in servoy 4.0.

It identify the view correctly as a view, it allows me to choose the view when I create a form.

When I launch the client, an error says basically: no primary key on your view…

I know that there are no primary key on the view, but there is one on the base table…

Can any one help me on this?

Thank you very much

Philippe Beaulieu

2

You can set the row ident property on one or more columns that together uniquely identify a row.

Servoy must have info to identify each row uniquely. Usually by PK, but if no PK is available, you can manually set the Row Ident property on 1 or more columns in the DataProvider dialog

Paul