First of all, I am new with Servoy so I am probably doing something wrong and will be very grateful for any help.
We have an oracle table with over 600 columns and approximately 300,000 records. So as avoid the problem of the long time it takes to load the table (it takes over 5 minutes to allow selection of a field once the table is selected as the dataSource, we created a view with only … columns but now we are getting an error that the view requires a primary key. My understanding from our DBA is that views do not accept primary keys.
Any suggestions???
In advance thank you!
Hi,
First of all welcome to Servoy ![:)]( "Smile")
.
When a table (or a view in this case) doesn’t have a primary key defined on it then Servoy will complain. Servoy needs an identifier to load a record.
However you can assign one or more columns inside Servoy as identifier (ident) columns when you open up the table view.
Does your view have a unique column or a combination of columns ?
yes it does. The ssn. We are also in the process of creating another one with the row identifier, it should be unique. I found something in the Servoy Developers Version 4 User guide, sevction 9…3.3 Custom Row identifier that mentions how to make a column a primary key (pages 207, 208,209). Only problem is that the PK identifier does not show… See print screen.
Thank you so much for the help…
Rodrigo
Hi Rodrigo,
The row_ident is in this case the ‘primary key’. You can’t select ‘PK’, it will only show ‘PK’ when it defined as such in the database.
In the end it’s just a row identifier for Servoy so there is no problem (as long as the column or combination of columns are indeed unique).
You are good!!! Thank you very much. It’s working now.
