DESPARATE !!! - Db Locking (PLEASE HELP)
Posted on 1997-10-23
I have a serious problem.
My application has multiple screens. A sub-screen inputs
data into a database using Ttable components and SQLQueries all linked to each other. Calculations are also done and the results are also entered into the databas.
Another screen calls a report that reads the data from the same table that was enterd into previously.
I run my application and go down to the input screen and update the tables referred to previously. then I exit from that screen and go to the reports screen. When I run the report it does not include the updated data that I had entered just a moment ago but insted gives me the old data that was in the table.
If I terminate my application and re-run it going straight to the the report screen and execute the report THEN only does the report contain the updated data . I repeat the process of entering the data and calling the report and the same problem occurs .
What is going on here?
Why does the report not give me the data that I had just updated while the program is running.
Why does the application have to be terminated and re-run for the report to contain the updated data.
Posted 97/10/23 at 2:25am GMT.
Please answer as soon as Possible ....I am Desparate!!