Hello friends,
Need a suggestion for a problem.
Iam working on a financial accounting package where the frontend is VFP and backend is Oracle.
Problem is :
I need to update few updatable views (Tables of Oracle) with the latest value while i perform a update in transaction. Now as im using
Begin Transaction and End Transaction the problem faced is that in case if other user update in oracle table in between the process of my transaction execution i get wrong values as a result. For eg.
a view field consiting of a value 1000 other users update to 1000+500
hence in table of oracle i get 1500 but my view in transaction has a value of 1000 which is wrong. Hence all my operation at this time on view is with old value.
Using Requery() can be a solution but not the best as it takes time and looses my record pointer which number of times creats problem.
Aashsih