Well, surely there are several opinions but having a column for keep the
current stock usually is not a good choice. It is better to calculate when
you need it.

Greetings.

Walter.

On Wed, Dec 26, 2012 at 9:12 PM, Andrew Gable <andrew.gable@...>wrote:

> **
>
>
> Hello everyone,
>
> Just a quick question. I have 5 font end terminals connected to a firebird
> 2.1 server
> how would it handle say all the front end apps updating the same record
>
> eg a item 1001 is sold on the front ends and when the transaction is done
> the front ends find the product and does current stock -1 and then does a
> update on the record to save the new stock level into the database
>
> is this fine or is there something better I can do so the records do not
> get corrupted
>
> thanks (I know it is a daft question but I've never had more then 2
> machines on the server)
>
> Andy
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]