OraFAQ Forum: Forms » Cancel Add (create record) Transaction

Home » Developer & Programmer » Forms » Cancel Add (create record) Transaction

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

Cancel Add (create record) Transaction [message #180028]

Thu, 29 June 2006 20:24

cong
Messages: 25
Registered: June 2006

Junior Member

After the user clicks the Add button, a new record is inserted. All fields are required. If the user decides to close or exit from the module, the message "Field must be entered" is displayed. To be able to exit, the user needs to enter data, click Delete button then, Exit and just cancel the transaction.

I want to add a Clear Record button that will be used to cancel Add or Modify transaction. How do I go about it?

Also, how do I make the label in the push button, 2 lines? Meaning, Clear then, next line is Record. This is because of space constraint. Thanks!

Thanks for replying to my previous question!

Report message to a moderator

Re: Cancel Add (create record) Transaction [message #180288 is a reply to message #180028]

Sun, 02 July 2006 21:35

cong
Messages: 25
Registered: June 2006

Junior Member

I tried setting the required property of the columns to false after clicking cancel record button but still, the message Field must be entered is displayed. Pls. help.

Report message to a moderator

Re: Cancel Add (create record) Transaction [message #180322 is a reply to message #180028]

Mon, 03 July 2006 02:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

To make a label go onto a second line then use the set_item_property and in the text field use something like 'text for line 1'||chr(10)||'text for line 2'.

You should be able to enter that literal via the Form Builder property sheet by double clicking the label literal field and then pressing the 'enter' key to give you the line break that you want.

David

Report message to a moderator

Re: Cancel Add (create record) Transaction [message #180324 is a reply to message #180028]

Mon, 03 July 2006 02:03

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

The reason you have to delete the record is that you have touched at least one of the new fields. I suggest that you use the When-Create-Record trigger to populate any needed information but that you DO NOT set any fields to NULL.

Please post how you are currently populating a new record.

David

Report message to a moderator

Previous Topic:	Module not loading
Next Topic:	Exporting to Excel;

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 01:46:45 CST 2025