Question: Can you help me with a coding example showing how to program the handle of the database errors. Until now I always used "on E: EFIBError do ..." and do not know how I can program this in FIBPlus.

Answer: You can use both - standard exceptions (EDatabaseError) and specific FIBPlus exceptions. For example:

try
 something
except
 on E: EFIBError do ...
end

FIBPlus exceptions are described in fib.pas:

EFIBError = class(EDatabaseError)
private
  FSQLCode: Long;
  FIBErrorCode: Long;
  FSQLMessage :string;
  FIBMessage :string;
  SenderObj :TObject;
  public
    constructor Create(ASQLCode: Long; const aMsg: String;Sender:TObject);
    constructor CreateEx(ASQLCode: Long; const IBMsg,SQLMsg: String;Sender:TObject);
    property SQLCode : Long read FSQLCode ;
    property IBErrorCode: Long read FIBErrorCode ;
    property SQLMessage :string read FSQLMessage;
    property IBMessage :string read FIBMessage;
end;
EFIBInterBaseError = class(EFIBError);
EFIBClientError = class(EFIBError);

For more details about this please read an article "FIBPlus: handling database errors"  

Preview text: 
Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...

Navigation



When I had to find the best component to connect to my Firebird databases, FIBPlus imposed itself with its rapidity and reliability. Most importantly, it continued to evolve to be even better and whenever we had a problem, it was fixed promptly by Devrace team. We use FIBPlus in many projects related to Healthcare. We have hundreds of users who access databases up to 8 GB in size. I think there are many good third-party components out there, but not so many with an excellent support like the one provided for FIBPlus components. Thanks to you. >>

Evelyne Girard, Canada
FOR CUSTOMERS
Download full versions and updates in your Personal Area