Fixed it:

gfix -mend
I didn't know about the mend option, but it fixed the problem in a jiffy.

There were actually three records with corruption issues. I am
interested in finding out what may have caused this corruption (but
after using the computer it is being run on, I am not overly surprised
there is problems). If you have any idea, let me know.

Adam

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
>
> I have narrowed problem my problem down to 1 record in 1 table. It is
> not a particularily important record, so I just want to delete it.
>
> delete
> from tableA
> where ID=450;
>
> causes a "internal gds software consistency check (cannot find record
> fragment (248))" error after which you need to close isql.
>
> You can not select this record or backup the database either, the
> same error.
>
> Any ideas?
>
> Adam