[comp.databases] Oracle SQL*Forms

larry@edison.UUCP (Larry Lee) (08/25/90)

I am writting a Form using SQL*Forms ver. 2.0 running on Ultrix ver. 3.1.

Problem : A form that displays some data on the screen.  User then scroll
          down or up to view data on the screen.  They can press a predefined
          key to run a C program and this program will perform some calculation
          then change the data and update the database. 
          
Question : How can I after the program is run, return to the form with the
           newly updated data or refresh the screen so the user can see
           the result of the program?  Of course, the user can re-query the
           form and be able to see the new set of data.  Unfortunately, this
           is not what they want, they like to see it happen automatically.
           I like to if possible, preserve the original query.  That is,
           if the user query on a key field and scroll down from one record
           to another, I like to be able to do this after the new data has
           been displayed.

Is there anyone that have done this before?  I am very slow to find a way
to solve this problem.  

Thank you.