Andres Rormoser
|
| Posted: 08/25/2005, 8:00 AM |
|
Hi,
I have Table1 witch has a Unique Key based on two fields. I need to validate this in a
Editable Grid. I tried to do that on the OnValidate Event but there i don't have access to
all the rows that i'm going to insert, right? So my question is how do I trap SQL errors
and display a friendly message rather than the cryptic SQL Server message?
In the After Submit event Help one application saids: Processing query errors. But it do
not says how.
Thanks,
Andres Rormoser
|
|
|
 |
donrule
Posts: 2
|
| Posted: 09/06/2005, 5:56 AM |
|
I'm having the same problem. SQL allows me to check multiple fields to determine if it is a duplicate, but the errors it returns are not at all user friendly. Is there a way in CodeCharge to either check multiple fields to determine validation or change an SQL error message to make it more friendly? As an example, SQL is currently returning the following very unfriendly message: "Violation of UNIQUE KEY constraint 'IX_tblTapeRecordEOPf'. Cannot insert duplicate key in object 'tblTapeRecordEOPf'. (Microsoft OLE DB Provider for SQL Server)"
|
 |
|
|
