Oracle-L: Re: How to save changes before scrolling up/down?

From: sushil shah <sushils_at_INDIA.MASTECH.COM>
Date: Tue, 5 Mar 1996 01:05:40 -0500
Message-Id: <9603050621.AA04117@alice.jcc.com>

Change the procedure clear_master_details (if genetared thru default block facility) to cahange clear_block(ask_commit) to delete this line and put the post instead. This will work.

Best of luck..

Sushil

Date:          Tue, 5 Mar 1996 11:04:00 PST
Reply-to:      "ORACLE database mailing list." <ORACLE-L_at_CCVM.SUNYSB.EDU>
From:          "Imelda Setijadi ( imeldas)" <imeldas_at_EDBPO1.EDB.GOV.SG>
Subject:       How to save changes before scrolling up/down?
X-To:          oracle-l <ORACLE-L_at_CCVM.SUNYSB.EDU>
To:            Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.SUNYSB.EDU>

I have a base table block with only 1 record displayed at a time. User can update, insert new record and
scroll up/down using the scroll bar.

PROBLEM:-

I always get a prompt 'DO YOU WANT TO SAVE THE CHANGES YOU HAVE MADE?' before I can move on to the next or previous record. I need to suppress this message.

I have tried to issue a 'POST' in various triggers (eg. post-record, key-nextrec, key-prev-rec), but still unsuccessful.

QUESTION:-

Is issuing a 'POST' the solution? and in which TRIGGER should I put it in?
If 'POST' is not the solution? How can I overcome the problem?

thank's a lot!
Imelda

Imeldas_at_edb.gov.sg Received on Tue Mar 05 1996 - 01:21:50 CST