Re: Rollback in Forms..

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: Tue, 19 Oct 1999 16:15:51 GMT
Message-ID: <XO0P3.12$I4.989_at_nntp.csufresno.edu>

In article <7uh5ih$db6$1_at_news.worldcom.ch>, Olivier Régis <olivier.regis_at_duroblade.com> wrote:
>I want to have a rollback button which refreshs back the old data in Forms..
>
>My first idea was:
>
>in the when-button.... trigger:
>
>some check if rollback can be done,
>
>ROLLBACK
>go_block(master_block)
>/* the "Where clause" un the block proporties is already set to the good
>record */
>EXECUTE_QUERY;
>
>each time, the rollback ask if the user wants to save the changes..
>
>Why?--

Forms interprets a ROLLBACK; statement as a Clear_Form(Ask_Commit); If you want to unconditionally rollback everything, instead of the Rollback statement, use Clear_Form(No_Validate,Full_Rollback);

Steve Cosner

---

http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table. Received on Tue Oct 19 1999 - 18:15:51 CEST