First Union Securities, Inc.
I think you are getting the default pb error window as well as your message.
Try returning 1 from the event after you format your message. The following
is from the help file on the dberror event:
Return value
Long. Return code choices (specify in a RETURN statement):
0 Display the error message
1 Do not display the error message
Jim Anderson - *(704) 593-7034 <>< FDFX
Time flies like an arrow. Fruit flies like a banana.
-----Original Message-----
From: Theisen, Timothy J. [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 28, 2000 3:22 PM
To: 'PFCSig'
Subject: PFCSIG PFC/PB 7 - How do I issue a better message
for an SQL error (i.e. insert duplicate key) in the PFC save process?
I am trying to trap an SQL error(i.e. duplicate key on insert)
during the
pfc save process
and am trying to determine the best way to trap this and issue a
better
error message
than the standard PFC generated error message ... I have tried
putting the
code
in the dberror event and overriding the ancester code from u_dw,
and that
works ok
to give me my new error message, but then it also issues another
message
that seems to come from within the pfc somewhere else ... I am also
unsure
of
what may be affected by overriding the ancestor code in the dberror
event.
If anyone has ideas on the best way to do this, I would appreciate
it. Thx
in advance.
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE
COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
This is for your information only and is not an offer to
sell, or a solicitation of an offer to buy, the securities or
instruments mentioned. The information has been
obtained or derived from sources believed by us to be
reliable, but we do not represent that it is accurate or
complete. Any opinions or estimates contained in this
information constitute our judgement as of this date
and are subject to change without notice. First Union
Securities, Inc. (FUSI), or its affiliates may provide
advice or may from time to time acquire, hold or sell
a position in the securities mentioned herein. FUSI is
a subsidiary of First Union Corporation and is a member
of the NYSE, NASD and SIPC. FUSI is a separate and
distinct entity from its affiliated banks and thrifts.
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
