Re: Reporting uncommitted FORMS data

you could put the data into a temporary table. mark each record with a sequence number (one number for the set of records you are working on ) at runtime. Print the report on this table where the sequence is your number, then delete the table where the sequence is your number.

then go back and redesign the application.

Randy :)

Steven J. Perry (sjperry1_at_ix.netcom.com) wrote:
: I need to print a report of data on an Oracle Form (v3.0) which has not
: been committed. This is form 2 of 3 in an order entry sequence, and we
: don't commit the data until they are done with Form 3, however the user
: "must have" the Form 2 data on paper in order to complete Form 3.
 

: 1. Is there a way to write the uncommitted data to a flat file
: so I can call a shell script or Pro C program to print the report?
: 2. OR, is there some user exit I could use to run my Pro C program
: so that the uncommitted form data is available to it?
: 3. OR, am I missing some much easier way to get FORMS data on paper?
: Unfortunately the screen has a scrolling block so a screen print
: wouldn't quite cut it.
 

: Thanks in advance...
: --
: Steven J. Perry, Southfield, MI

--
    ..uu.                                     ----------------------
  .?$" '?i     .                              I  Randy DeWoolfson  I
 .T^M  ._at_"    d9    .     f   ,.un.  b,    i  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``"# `M   _at_"  I  randyd_at_cais.com   I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I        ,\//.       I
    &  'M ,P    `E  M   "$  Mux~      n!`     I        |o o|       I
   dk   `h"       ' j     " y"       *~       I====oOO==(_)==Ooo===I