RE: Constraint Violations

["Mangavalli, Ramanujam" <RamM@xxxxxxxxxxx>]

Mark,

I have no idea of how to handle this in Native IO. But if you can get the
constraint name, from the PSDS or somewhere else,  I can help you with
getting the actual fields/their descriptions to tell the user what is in
error.

But if you are using SQL, I can send you our standard message handler that
does this. It looks for 3 sql error messages - REf. Cst, Chk. Cst and the
trigger error. IF any of these exist, it retrieves the column descriptions
and sends a message to the stack level that you request.



-----Original Message-----
From: MWalter@hanoverwire.com [mailto:MWalter@hanoverwire.com]
Sent: Wednesday, October 03, 2001 11:12 AM
To: rpg400-l@midrange.com
Subject: RE: Constraint Violations



In which area of the File Information DS does the name of the constraint
exist?

<snip>
I post a generic message with the name
of the constraint in the second level text so that a programmer can
interpret for the user if required.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.