--- In ib-support@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
>What do you mean by "batches"?

Sorry, I'm not a native speaker of English. Let's call them "queries"
or "update processes" ...

>>If I stop the Firebird server while there is a running update
>>process, then I suppose that it could lead to data corruption.

>In a best-case scenario, stopping the server doesn't corrupt
>data.
...
>On a Windows server, it has a habit of being risky,
>especially if you have ill-advisedly set synchronised disk writes
off.

The reason I asked this was because I tried this "query cancelling
method",
and got a corrupted database. (Windows 2000 server, 5 HDs in RAID5,
Forced Writes = ON).
When I tried to make a backup, I got an error message: "Arithmetic
exception,
overflow or string truncation ...".

AFAIK, Interbase 6.5 has some query cancelling mechanism, hasn't it?

Thank you very much for your exhaustive help! I myself had something
similar
in my mind: updating data in smaller chunks, when possible.
All in all, there will be a lot of work and a good piece of
improvisation before I bring this new DB in a healthy state:
broken ref. integrity, broken constraints, etc. But
these "pleasures" are
already well known for you, I suppose ... :-)))

Best regards,
Robi