Referencial integrity automation check

Discuss all feature requests you have for a new Servoy versions here. Make sure to be clear about what you want, provide an example and indicate how important the feature is for you

Referencial integrity automation check

Postby gianni » Fri Jul 28, 2006 5:22 pm

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
gianni
 
Posts: 64
Joined: Sat Feb 12, 2005 2:26 pm
Location: Vercelli, Italy

Postby sbutler » Fri Jul 28, 2006 5:35 pm

Isn't that what foreign keys in the database are supposed to do?
Scott Butler
iTech Professionals, Inc.
SAN Partner

Servoy Consulting & Development
Servoy University- Training Videos
Servoy Components- Plugins, Beans, and Web Components
Servoy Guy- Tips & Resources
ServoyForge- Open Source Components
User avatar
sbutler
Servoy Expert
 
Posts: 759
Joined: Sun Jan 08, 2006 7:15 am
Location: Cincinnati, OH

Postby gianni » Tue Aug 01, 2006 9:29 am

Basically...YES!

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

Ciao,
Gianni
gianni
 
Posts: 64
Joined: Sat Feb 12, 2005 2:26 pm
Location: Vercelli, Italy


Return to Discuss Feature Requests

Who is online

Users browsing this forum: No registered users and 9 guests