In a recent Servoy training class I was leading, I was using the example_data db for an order-entry system we were developing in class. I started running into strange behavior when creating order_detail records related to orders, and I figured out what the problem is. Because others may use this db for learning purposes I feel it’s important to get this cleared up.
The order_details table has a complex primary key that is based on two foreign keys: orderid and productid. Both are flagged as pk, which is correct, but the problem is that they are also defined as Servoy Sequences. This is not OK, and it causes all kinds of problems when trying to create new order_detail records.
Is is possible for the default installation of Servoy NOT to create Servoy Sequences for those columns? And if not, then perhaps a simple order_detail_id column should be added, and it alone should be the primary key.