>>>Secondly I don't use SQL through; my application is using CA. And I do use SQLExec(). But the SQL Select/Insert/Update do not give me any problems since I learned how to catch them right at the point where they are executed. When I look at some customers' error log I see mostly the error caused by a problem instantiating objects. And so far, I have not learned how to catch those.
>>
>>CA is also SQL :). I use prg-based CA class and in each of the after* methods there's a check for the lResult parameter, and if .f., aError(ea), then olog.logArray(@ea).
>>
>>Just now I got the idea that I could pass this as a parameter - logging the state of the cursor adapter may also help.
>
>Maybe I should simply not have any bugs in my application and therefore won't need to log errors :)
Your app may be bugless and still have errors - caused by the surrounding OS, hardware, network, idiot (aka user).