I have an application that is using firebird 1.5.3 and connecting
using BDE components. I am slowly converting a section at a time to
IBO Components. one part of the APP has several users selecting items
from inventory and I am updating the qty by Selecting the current qty
in a select statement using a live query, setting to Edit state
decreasing the value then posting the record. I seem to be having
problems with the qty not getting updated correctly.

does someone have an air tight way to make sure the qty is decreased
and increased correctly as items are added to or cancelled off of an
order.

Any help would be greatly appreciated.