Re: Getting TAdoQuery extended informations about error


When using TAdoQuery, when an error occurs, we get a EOleException having an
ErrorCode member and a message member. is there any way to get more
informations about the exact error which occured ?

You can look at the TadoConnection.errors collection.

This is what you can extract

For i:=0 To ADOConnection.Errors.Count-1 Do Begin
wssource:= ADOConnection.Errors[i].Source;
stDesc:= ADOConnection.Errors[i].Description ;
wsState:= ADOConnection.Errors[i].SQLState;
iErr := ADOConnection.Errors[i].nativeError;
End;//For

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.