× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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






As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.