At 04:38 AM 9/09/2004 +0000, you wrote:

>Immediatly after I received a KeyViol complaint and found the the
>generator was delivering numbers less that max(Table.Id).
>
>A week or so later received same fault report on another table.
>
>Would this indicate that forced writes were off?

Even if forced writes were off, once a generator value has been delivered,
it can't be delivered again, regardless of what happens to writes in the
disk cache. I would rather look for (and kill) an application or a trigger
that is messing about with values that you expect to be delivered by the
generator - esp. those those that select max() and add 1; or read
gen_id(aGen, 0) and add 1. Those are your integrity-killers.

./heLen