BCB operates database to catch exceptions

点纹十二卷

I use BCB to access SQL Server. The new record does not catch the error returned by SQL. Please give pointers, thank you, :)
try
{
    this-> ADOQuery1-> Open ();
    this-> ADOQuery1-> Insert ();
     .....
    this-> ADOQuery1-> Post ();
    this-> ADOQuery1-> Close ();

}
catch (EDatabaseError * e) {
                ShowMessage ("Error");
                return;
        }

apple_058

catch(EDatabaseError *e) should
catch(EDatabaseError&e)

点纹十二卷

This is a newly added SQL statement. If there are duplicate records, it will be captured and prompted to have this record.

点纹十二卷

Now the program runs with an error as soon as there are duplicate records, the program is interrupted

点纹十二卷

Its prompt message is the EOleException class, and it cannot be caught with it. :(

apple_058

catch(...)
Look at

apple_058

or
catch (Exception&exception)

yjws121

try
{
    this->ADOQuery1->Open();
    this->ADOQuery1->Insert();
     .....
    this->ADOQuery1->Post();
    this->ADOQuery1->Close();

}
catch(Exception&e){
                ShowMessage(e.Message);
                return;
        }

点纹十二卷

It still doesn't work.

freedomsoli

try
{
...
}
catch(Exception&E)
{
  ShowMessage("Here is the best place to write the code where the function is located to help you find the place of the error" +E.Message);//It is better to add E.Message here, because if you do not add this sentence, only show your error Prompt message, you do not know why it is wrong

}