Subject | How would Firebird handle this. |
---|---|
Author | Andrew Gable |
Post date | 2012-12-27T01:12:46Z |
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]
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]