Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: A Successful Commit Returns 'Data Not Saved'

Re: A Successful Commit Returns 'Data Not Saved'

From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 1997/11/23
Message-ID: <65aedr$hhf@camelot.dsccc.com>#1/1

You need to move your insert code into the on-insert trigger. put commit; in your when-button trigger.

ªü´ö Thenardier (Thenardier_at_POBoxes.com) wrote:

: In a form i have items which Base Table Items properties
: are FALSE. For them I need to manually write a INSERT statement
: to insert new records to a table and then COMMIT (I put those
: codes in the When-Button-Press trigger in a button). Yet after
: a successful COMMIT (from SQLPlus i know so), the form
: display a FRM-##### message saying that no data has been saved.
 

: How can i make it return a data-successfully-commit type of message?
: Set the Base Table Item to TRUE? Tried. And no use.
 

: It's quite simple (to u), isn't it? What if i want to use the info in
: the items, do some calculations, and then INSERT them to more than one
: tables?
 

: Thanx in advance!

: Cheers,
: Thenard

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.
Received on Sun Nov 23 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US