NonBlocking & breakexec -> exception

[Ludek]

Hi, I am just evaluating odac (as a long-term sdac user for new application) and i have following problem:
If i open a query in non-blocking mode and call breakexec, exception appears. how can i get rid of this one exception? (users should not see the exception dialog). for me, it is enough to get the onafterexecute event with result = false (which works fine).
Thanks, Ludek.

[Ludek]

i've found following:
http://www.devart.com/forums/viewtopic.php?t=993

but: how could i change the onerror event to make such exceptions disappear? all other kinds of exceptions should be shown to the user, just this one on breakexec should not appear.

[bork]

Hello

You can write the following event handler for your OraSession:

Code: Select all

procedure TForm1.OraSession1Error(Sender: TObject; E: EDAError; var Fail: Boolean);
begin
  if E.ErrorCode = 01013 then
    Fail := false;
end;

It will be catch the ORA-01013 error but other errors will be shown to user.

[Ludek]

Thanks, it works. but - isn't there some oraquery-level solution? I mean some proprty or event directly in the toraquery component, not only this one session-wide.

[bork]

Now all Oracle errors are caught by TOraSession. We will investigate the possibility of adding the OnError event to the TOraQuery in one of the next builds/versions of ODAC.