It cannot be an key violation error because i am using generator.
It must be a component error or server error.

One Time, I have seen a strange error.
Machine is Win95.
My table id field value is 345, but my generator is 320.
And i get key violation error.
There is a problem but i can not understand.
What is the problem.


ibrahim Bulut
Software/Database Developer
Republic Of Turkey

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, September 12, 2003 11:40 AM
Subject: Re: [firebird-support] Update Failed


> At 10:07 AM 12/09/2003 +0300, you wrote:
> >Hi,
> >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. :->
>
> heLen
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>