Subject Re: [firebird-support] Update Failed
Author Helen Borrie
At 10:07 AM 12/09/2003 +0300, you wrote:
>I am using Delphi 5, Interbase 6.2 and IBX.
>I sometimes get "Update Failed" error while trying to insert a new record.
>But My Update Sql, Insert Sql statements is not wrong.
>Rarely i get this error message.
>Why i get this error message.
>I am not updating or deleting an existing record.
>I am inserting a new record.
>What is the problem, I can't understand.

If an insert fails, it's probably a key violation or some kind of
validation error.

>Is problem about IBX components or Interbase 6.2

Probably neither. If your program doesn't intercept the exception and find
out what it was, I guess the exception just filters up to the generic DML
error "update failed".

>In a few days, i want to change my database to Firebird 1.5.

Good idea. But Firebird returns exceptions too. :->