Re: R: SQL help

["Peter Dow" <maillist@xxxxxxxxxxxxxxx>]

Hi Domenico,

One approach is based on the fact that constraint names can be quite long
(128 characters rings a bell) so that for the constraint you mentioned
below,just make the name An_order_item_is_being_loaded_when_no_order_exists.
Then when you get a message that the constraint is being violated, it
includes the name of the contstraint which explains the problem.

This worked pretty well in one system I worked on where a Visual Basic
program used ADO to access the AS400 data, but ADO did not always return the
name of the constraint.  However, when it did, the long name explained
itself.

hth,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


----- Original Message -----
From: "Finucci Domenico" <Domenico.Finucci@Fiditalia.it>
Sent: Wednesday, April 24, 2002 7:47 AM
Subject: R: R: SQL help


> In other words, in order to send a message such: "an order item  is being
> loaded while no order exist" you need to know the constraint details, is
> that true ? I was asking if a more general purpose approch exists.
> Sincerely
>
> Domenico Finucci
> Fiditalia , Milano, 02- 4301-2494