Home » Developer & Programmer » Forms » problem in display only.
problem in display only. [message #211085] Tue, 26 December 2006 03:20 Go to next message
lunate
Messages: 74
Registered: October 2006
Location: Pakistan
Member

hi all,
i have a small problem ,
i have a datablock v_ballot,and a
control block with a text field TXT,and a Button.
i put a small program unit at a when-button-pressed.

PROCEDURE BAL_YRS IS
BEGIN
SELECT YR,LDR_NO INTO :V_BALLOT.YR,:V_BALLOT.LDR_NO FROM V_BALLOT WHERE YR=:YRS;
END;


it displays year and leader no in the text fields of DATABLOCK .ok

but when i close my form the it ask for(GENRATE A MESSAGE).

Quote:
DO YOU WANT TO SAVE THE CHANGES YOU HAVE MADE?


I DON'T WANT TO SAVE THESE VALUES IN THE V_BALLOT .

HOW CAN I SET THIS PROGRAM IN A WAY THAT FORM WILL NEVER ASK(GENERATE MESSAGE) TO SAVE IT.

HOPE U UNDER-STAND MY problem.
REGARDS.
Re: problem in display only. [message #211109 is a reply to message #211085] Tue, 26 December 2006 06:59 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would such a code in the form-level KEY-EXIT trigger do any good?
EXIT_FORM (NO_VALIDATE);
Re: problem in display only. [message #212111 is a reply to message #211085] Wed, 03 January 2007 17:49 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please use 'code' tags to delineate your code - it makes it easier to read.

The message comes about because your code is updating a database field. If ':V_BALLOT.YR' and ':V_BALLOT.LDR_NO' are for display purposes only then turn the 'Database Item' property of these items to 'No'.

David
Previous Topic: How can I run Forms application without Aplication Server
Next Topic: Running Report 9i from Form Builder 9i.
Goto Forum:
  


Current Time: Thu Dec 12 07:48:49 CST 2024