zac
asked on
Exceptions, MS SQL & ODBC
When I add a record which invalidates referential integrity to a MS SQL database (using ODBC) in code I recieve no exception, however when I enter the same data using a visual component I recieve the exception - how can I get the exception to be generated by my code?
ASKER
The problem is that although an exception should be generated by the code, it is not!
I have found a work-arround which is to use queries, however I would be interested in finding out the reason for this strange behaviour.
I have found a work-arround which is to use queries, however I would be interested in finding out the reason for this strange behaviour.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
try
{ ... your code that invalidates referential integrity }
except
raise; { or however you want to handle it }
end;