Handling Database Exception with ADO
2004-01-16 05:47:49 PM
delphi267
I had the following handling routines in Paradox/Interbase for key violations:
try
tblSample.post;
except
on E: EDBEngineError do
if E.Errors[E.ErrorCount - 1].ErrorCode = 9729 then begin
.....................................
How would I trap the same error with ADO?
Can I retrieve an SQLcode like "-803" or "100" (std SQL errors code)?
Tanks