We are attempting to link Servoy to an existing Pervasive v11 database in order to create several custom entry screens that extend the functionality of the system. The current implementation of the database and the way the database connects to Servoy through JDBC does not provide a PK for any of the tables to Servoy and cannot be modified in any way (this would include read-only flags, null-flags, etc). Since we will only be using these tables to expose "read only" information and to populate valuelists in our new solution, it should be perfectly acceptable to allow the database to connect with flat tables (e.g. no PK). Note that the primary tables containing new data within the solution will have a PK. Yet - Servoy does not seem to allow a connection to any database table that does not have a PK.
Please advise a workaround to this limitation. Perhaps some sort of "read-only" connection mode that ignores all the PK logic.
Please advise