Chris,
how did you populate this table? Any triggers defined? This kind of
error normally comes from a programming mistake rather than database
corruption, so show us some code. Database corruption is rare (I have
never experienced it, whereas I've done lots of programming mistakes),
and when it occurs it makes records or databases inaccessible, it
shouldn't change values.

Set

--- In firebird-support@yahoogroups.com, "Christianto Tjahyadi" wrote:
> Fyi, no one updated the table.
>
> --chris
>
> ----- Original Message -----
> From: "Martijn Tonies" <m.tonies@u...>
> To: <firebird-support@yahoogroups.com>
> Sent: Tuesday, April 20, 2004 1:58 PM
> Subject: Re: [firebird-support] Database Corrupted?
>
>
> Hi,
>
> > Today, I face a problem with my database.
> >
> > Yesterday night, table A contains:
> >
> > Part_no Part_name
> > ===============
> > A001 Part A001
> > A002 Part A002
> > A003 Part A003
> >
> > This morning, when I will start to entry, I see table A contains:
> >
> > Part_no Part_name
> > ===============
> > A001 Part A002
> > A002 Part A003
> > A003 Part A004
> >
> > How this can be? Is my database corrupted?
>
> Or someone updated your table.
>
> > Btw, how to check a database corrupted or not?
>
> You can validate your database with the command line tool "gfix".