OraFAQ Forum: Forms » problem in display only.

Home » Developer & Programmer » Forms » problem in display only.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem in display only. [message #211085]

Tue, 26 December 2006 03:20

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.

Report message to a moderator

Re: problem in display only. [message #211109 is a reply to message #211085]

Tue, 26 December 2006 06:59

Littlefoot
Messages: 21818
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);

Report message to a moderator

Re: problem in display only. [message #212111 is a reply to message #211085]

Wed, 03 January 2007 17:49

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:21:08 CDT 2024