OraFAQ Forum: Forms » how can i do to make the button

Home » Developer & Programmer » Forms » how can i do to make the button

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

how can i do to make the button [message #614482]

Thu, 22 May 2014 05:31

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi all,

when i use 'insert record' in the default toolbar to create a new record, the cursor focus on the required text field, i can use 'delete record' in the default toolbar to delete it

but now ,i add a button with a pressed trigger in the form and write 'delete_record' command in the trigger.

when i use 'insert record' in the default toolbar to create a new record, the cursor focus on the required text field,i can not use the button to delete it and show the error 40202

i want to know how the 'delete record' in the default toolbar can do this.

Thanks

Report message to a moderator

Re: how can i do to make the button [message #614484 is a reply to message #614482]

Thu, 22 May 2014 05:39

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle

FRM-40202: Field must be entered.

Cause: You have not entered a value (or you have deleted a value) in a field that requires data input.

Action: You must enter a value in this field.

It appears that you didn't follow the same steps in both cases.

Report message to a moderator

Re: how can i do to make the button [message #614485 is a reply to message #614484]

Thu, 22 May 2014 05:41

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Quote:

It appears that you didn't follow the same steps in both cases.

Thanks for early Littlefoot ..I didn't get your point could you please help me on this ? If possible please send me the steps please... Smile

Report message to a moderator

Re: how can i do to make the button [message #614487 is a reply to message #614485]

Thu, 22 May 2014 05:48

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What I meant to say was that "field must be entered" doesn't depend on DELETE_RECORD location (default toolbar, your own button, whatever).

Delete button which is located in Forms toolbar deletes current record.

Where is your DELETE button? Is it in the same block as the record you are trying to delete? If not, that might be a problem because you are navigating out of the current block so - if some "required" items are empty, Forms will complain about it. Therefore, put the button into that block (optionally, set number of items displayed property to 1).

Report message to a moderator

Re: how can i do to make the button [message #614488 is a reply to message #614485]

Thu, 22 May 2014 05:49

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

The problem is becuase the button is in a different datablock. Pressing it causes forms to shift focus to a new datablock, which in turn fires the validation on the old datablock, and so you get a validation error.
The toolbar isn't in a datablock, so clicking on it's buttons doesn't change the current datablock.

Report message to a moderator

Re: how can i do to make the button [message #614489 is a reply to message #614488]

Thu, 22 May 2014 06:02

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Thanks to Littlefoot and cookiemonster... Smile

Report message to a moderator

Re: how can i do to make the button [message #614493 is a reply to message #614489]

Thu, 22 May 2014 06:39

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

My another question is,

1)when i click 'insert record' in the default toolbar to create a new record,
2)i can use 'delete record' in the default toolbar to delete record which is creating. but the button i add cannot.

so i think record can be deleted which is not yet saved.

in other word how can i cancel the insert action?

Could you please explain?

I think i have use COMMIT_FORM in the Button, after delete_record built-in in the Button right?

Report message to a moderator

Re: how can i do to make the button [message #614495 is a reply to message #614493]

Thu, 22 May 2014 07:41

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

What does happen when on click on the button?
Have to moved it to the same datablock as the record?

Report message to a moderator

Re: how can i do to make the button [message #614496 is a reply to message #614495]

Thu, 22 May 2014 07:50

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Quote:

What does happen when on click on the button?
Have to moved it to the same datablock as the record?

1) clicked on the execute_query , records diplay
2) by mistake i clicked the insert(+ symbol)
if i want to go the(move to the next step) then i am getting error 40202.

In the table one column had not null...

Report message to a moderator

Re: how can i do to make the button [message #614497 is a reply to message #614496]

Thu, 22 May 2014 08:05

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi cookiemonster,

1) click on the execute_query in the tool bar
2)i clicked on the insert from the Tools

it shows an error, so how to move cursor, i mean i unable to go the next or previous records.

Thanks

Report message to a moderator

Re: how can i do to make the button [message #614499 is a reply to message #614497]

Thu, 22 May 2014 08:26

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

have you moved the button to the same datablock as the record?

Report message to a moderator

Re: how can i do to make the button [message #614539 is a reply to message #614496]

Fri, 23 May 2014 00:09

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

mist598 wrote on Thu, 22 May 2014 14:50

1) clicked on the execute_query , records diplay
2) by mistake i clicked the insert(+ symbol)
if i want to go the(move to the next step) then i am getting error 40202.

There are items that get their values upon creating a new record (that might be non-displayed items, so you - as an end user - don't even know that, but - as a developer - you should). When you try to navigate out of that record ("move to the next step"), Forms knows that you kind of started to enter values into that record but some required items are still empty. Therefore, you first have to delete that "empty" record (you created by mistake), and then you'll be allowed to move elsewhere.

Report message to a moderator

Previous Topic:	Separate Frame applet issue
Next Topic:	Changing radio button color to default or unspecified

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 01:11:39 CST 2025