At 05:53 AM 6/09/2005 +0000, you wrote:

>Thank you very much of your advice, I must admit we have a bad
>database design here, because the process is relying on tables' state
>through out the codes, and a hard commit would change these states.

In short, that is nonsense, Duncan. Both soft and hard commits change the
database state.

And, whether the database design is bad or not, it's not the database
design that is causing your problems, but the application design. You are
looking in the wrong place.

./heLen