how can i do to make the button [message #614482] |
Thu, 22 May 2014 05:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a59247482a11edb9544247f102223e8d?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
Re: how can i do to make the button [message #614488 is a reply to message #614485] |
Thu, 22 May 2014 05:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 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.
|
|
|
|
|
|
|
|
|
Re: how can i do to make the button [message #614539 is a reply to message #614496] |
Fri, 23 May 2014 00:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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.
|
|
|