Subject Re: [IBO] Re: Opnions on this...
Author Carlos H. Cantu
Yes, I tought about that too, but the "process" button is not an option to


WarmBoot Informatica -
Interbase-BR -

pucb> --- In IBObjects@y..., "Carlos H. Cantu" <ibo@w...> wrote:
>> Hi everybody !

pucb> To avoid deadlocks I use the concept of "Processed Invoce", that is
pucb> when the user is typing it I maintain an AutoCommit ReadCommited
pucb> transaction, when he presses the "Process" button I start a
pucb> transaction , update stock , and change status to "Processed".

pucb> If the user wants to change a processed invoice I turn cached updates
pucb> on and when he presses the Apply button I update stock inside a
pucb> transaction.

pucb> The good thing with this approach is when the invoice is been typed
pucb> Interbase is validating things for me, and I get no deadlock, and the
pucb> ability to type an purchase invoce go to lanch and finish it later,
pucb> is very good, specially when you're calculating products costs
pucb> automatically, considering taxes (whe have many in Brazil).

pucb> Hope this helps,

pucb> Geraldo Lopes de Souza

pucb> Your use of Yahoo! Groups is subject to