Kbase P85669: SQL-92 Error: 'Cannot work without primaryKey on table <tablename>'
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/10/2004 |
|
Status: Unverified
SYMPTOM(s):
Error: 'Could not retrieve from data'.
Error: 'Cannot work without primaryKey on table <tablename>'
Trying to access a progress database table using the 'Servoy Developer'; a third party report development tool.
Connecting to the Progress database using a database server URL similar to:
jdbc:jdbcprogress:T:hostname:9999:sports2000
and the Progress JDBC driver:
com.progress.sql.jdbc.JdbcProgressDriver
CAUSE:
The table involved does not have a primary unique index defined.
FIX:
Define a primary unique index for the table.