Try-Except vs OnError for MyConnection and MyQuery

[TheLion]

Hi

Running MyDAC v3.50.0.16 with Delphi 5 on MySQL 4.0.23-classic

I have a problem with getting a error message out of my program, for a simple Select statement that fails.

None of the OnError events cath the fault. It does get trapped into the Except-End loop. Is there any why I can get an error message from within that loop?

Btw. if I copy the Select statement from my errorlog and paste it in the query browser it works!!!

[Ikar]

OnError determines type of the exception that will be generated on error (EMyError or EAbort). In both cases to handle errors in the queries you need try..except block.

> Btw. if I copy the Select statement from my errorlog and paste it in the query
> browser it works!!!

Please send us complete small sample to demonstrate it and include script to create server objects.

[TheLion]

Hi

I have a Try Except block. But how do I get an error txt string from inside this block. I need that to save it to my Log, so I can see what goes wrong.

In the different OnError... events I have EDAError or EDatabaseError and can get an error text message from that type. My Question is how do I get an error text from within the Try Except block.

My Main program works on 2 servers, but not on the 3th one. If I make a small sample program, that works on all 3 servers!!! I have to find out what is wrong. Normally any errors get trapped in an OnError... event for either MyConnection or MyQuery. But this one only get to the Except-End part of the Try Except block!!!

I use these onerror methods.

Code: Select all

MyQuery.Connection.OnError
MyQuery.OnDeleteError
MyQuery.OnEditError
MyQuery.OnPostError
MyQuery.OnUpdateError 

[Ikar]

> how do I get an error text from within the Try Except block.

You should use the next construction:

Code: Select all

try
except
  on e: EMyError do begin
    ...
  end;
end;

[TheLion]

Hi

Thats way to simple Why didn't I think of that!!!!

That will solve my problem

Thank you