Following scenario:
Since I want to use PostgreSQL sequences for primary keys, I create skeleton tables outside Servoy and restart. Fine. Then I go into the field definitions and tell Servoy what my primary key is and what sequence to use for the primary key generation. Fine…
unless you pick the wrong field as pk. In a table of transactions, I selected my invoice id as pk instead of the transaction_id. Since my invoices contain multiple transactions, my invoices displayed the same line item several times. The bizarre thing was that all the totals and taxes calculated fine…
Servoy gave me no warning that the field I was using for a PK had repeated values.