Re: Some database discussions...

Nothing provides such features. Even traditional RPG. You had to code
for it. Even before any of these type of constraints.

Now, you have to be more thorough on your writes to check the error codes
and error messages. Let's look at CPF502F for example. If you get that
then it is the programmers job to see if parameter &16 is 'MycolIsNotYorN'
and decide if the user can determine the message from the constraint name
or present a prettier message and position the cursor on the correct
position and all that jack.



Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Nathan Andelin <nandelin@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 05/17/2017 10:26 AM
Subject: Re: Some database discussions...
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

How did the parent know to chain out to the child on which column to
ensure that there was no match and therefore it would be safe to remove
this parent row?

My problem with DB defined RI constraints is with the generic
non-descriptive error messages, and that the error handling doesn't
provide
for cursor positioning and highlighting on relevant columns.

I may be missing something. For shops that implement DB defined RI
constraints, how do they handle user interface requirements (i.e.
friendly,
meaningful error messages, cursor positioning on relevant columns, and
highlighting)?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD