Hi Andrew, search the internet for "transaction isolation levels". It will
give you a broader sight of how database systems in general handle this
kind of thing you're speaking of.

On Thu, Dec 27, 2012 at 12:15 AM, W O <sistemas2000profesional@...>wrote:

> 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]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>


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