Use SQLCA.SQLDBCODE to get The database vendor's error code. wirte your own error message according to the error code.. I hope this might help you Raj ----Original Message Follows---- From: "Theisen, Timothy J." <[EMAIL PROTECTED]> To: "'PFCSig'" <[EMAIL PROTECTED]> 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? Date: Wed, 28 Jun 2000 14:21:32 -0500 MIME-Version: 1.0 Received: from [198.3.220.11] by hotmail.com (3.2) with ESMTP id MHotMailBB23B4A90065D820F3A0C603DC0BD6A90; Wed Jun 28 14:10:10 2000 Received: (from majordom@localhost) by mango.rssi.com (8.8.8+Sun/8.8.2) id PAA15478 for pfcsig-outgoing; Wed, 28 Jun 2000 15:42:16 -0400 (EDT) Received: from mhro1.mayo.edu (mhro1.mayo.edu [129.176.100.75]) by mango.rssi.com (8.8.8+Sun/8.8.2) with ESMTP id PAA15474 for <[EMAIL PROTECTED]>; Wed, 28 Jun 2000 15:42:08 -0400 (EDT) Received: from excsrv15.mayo.edu by mhro1.mayo.edu with ESMTP for [EMAIL PROTECTED]; Wed, 28 Jun 2000 14:20:06 -0500 Received: by excsrv15.mayo.edu with Internet Mail Service (5.5.2650.21)id <NWYSQ1P0>; Wed, 28 Jun 2000 14:21:37 -0500 >From [EMAIL PROTECTED] Wed Jun 28 14:13:02 2000 X-Authentication-Warning: mango.rssi.com: majordom set sender to [EMAIL PROTECTED] using -f Message-Id: <[EMAIL PROTECTED]> X-Mailer: Internet Mail Service (5.5.2650.21) Sender: [EMAIL PROTECTED] Precedence: bulk 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] ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > [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]
