>I solved the problem with locking key-table before transaction and then doing requery for needed views. Performance would be better with just REFRESH() but..
That's exactly what you have to do. There is no work around. Locking the record/table forces a refresh of the data. You will have the latest and greatest and be able to change it without someone else messing up your calculations.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao