Subject general advice for troubleshooting firebird (was: unable to delete ...)
Author kaczy27
Hello,

I am seeing similiar message about ten times a week:
"Check your server and client libraries, ensure you use fbclient.dll
for firebird, check your error message files are for current
version, change extension gdb to fdb on windows, you can't/shan't
change metadata during production phase"

how about making top ten things to check if firebird behaves strange?
and put in the docs (with big bad red letters :) ). Did you notice
how rarely there are questions about forced writes on windows -
everybody follow the docs here. It is written three or so times that
it is a road to corruption.

and don't get me wrong, you helped me many times and I'd like to
hope others too - that is just one way of doing it - summarise the
simple things to check first

OTOH, maybe it should be posted to the firebird-docs

CUIN Kaczy

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> At 12:54 PM 31/08/2004 +0000, you wrote:
> >Hi
> >
> >I am using a trial version of EMS's IB Manager, that seems to have
> >been working fine, but now when I try and delete data from one of
my
> >tables i get the error:
> >fmtableview.frmdata.datad.deletequery: arithmetic overflow or
> >dicision by zero has occured. arithmetic exception, numeric
> >overflow, or string truncation.
> >
> >Can anyone give me an idea of whats going on?
>
> You've got an exception, but you're getting the wrong message.
Most likely
> you have the wrong firebird.msg file on the server or the client.
If it's
> an old interbase.msg file your application is reading, it would be
worth
> checking that that client has the right client library, as well.
>
> ./heLen