Referencial integrity automation check

Classic Servoy
1

Servoy is enabling to define relationship at logical level; there are three types of relation definable:

  1. Real 1-N relation
  2. Usage N-1 of relation defined at #1
  3. Logical relations involving variables

I’d like Servoy:
to generate constraints to maintain referential integrity into database supporting in some way this feature
and
to automatically generate code to maintain referential integrity for those database not supporting this feature.

Database supporting referential integrity could do it in two ways:

  1. Declarative
  2. Programmatically (with a stored procedure)

This very generic functionality could save tons of coding to anyone.

I am available for more detail on the functionality request.

Gianni

2

Isn’t that what foreign keys in the database are supposed to do?

3

Basically…YES!

To improve data consistency and to write less code in solutions/modules…maintaining full portability and consistency between various DBMS.

Ciao,
Gianni