🚀 go-pugleaf

Hi there !!

We are implementing a multi-user system with Delphi 6 (BDE) and
Interbase 6.5. We are using normal queries and stored procedures. We
use database-transactions to implement our multi-user system. The
system itself works fine, but we can't separate the different BDE
error codes. We always get a "General SQL error" (BDE code 13059). But
we want to handle the errors seperate, such as BDE error 10259 (Record
changed by another user) or 10260 (Record was deleted by another
user).

After we start the transaction, we tried the delphi (pseudo) code
below:

Try
  //Execute the query or stored procedures
  Database.Commit
Except
  on E:EDBEngineError do
  begin
    for i:=0 to ErrorCount - 1 do
    begin
      ShowMessage(IntToStr(Errors[i].ErrorCode))
      //this is always 13059, while we want it to be
        10259 or 10260 depending on the user interaction
      Database.Rollback
    end  
  end
End

Our BDE configuration is this:

SQLQryMode : Server
Wait on lock : False
SQLPassthruMode : Not Shared

Thanks in advance !!

Greets Chris