NEXT BLOCK [message #315334] |
Mon, 21 April 2008 03:06  |
*munnabhai*
Messages: 157 Registered: March 2008 Location: Riyadh
|
Senior Member |
|
|
Hi guyz,
im stuck in one form need solution to get out from this.
i have three block in one forms
block A
block B
block C
block A & B have mater details relationship.
there are 10 fields in the master record.
after inserting in 3 fields the cursor should go to block C then block A and block B
i used key-nxt block (item level trigger as well block level trigger )on the 4th field in master table particular field
below is the code
GO_BLOCK('SIT_CONTRACTOR.COMPANY_NAME');
how to solve this please help.
Regards
|
|
|
|
|
|
Re: NEXT BLOCK [message #315424 is a reply to message #315334] |
Mon, 21 April 2008 08:03   |
Manoj.Gupta.91
Messages: 239 Registered: March 2008 Location: Delhi
|
Senior Member |
|
|
Hi,
what I understand from your problem........I'm proposing u a solution
On 3rd item of Block A
KEY-NEXT-ITEM TRIGGER
GO_ITEM( 'C.ITEM_NAME' ) ;
--This is the item in C block where you want to move your cursor.
then same action on the last item of C Block
GO_ITEM( 'B.ITEM_NAME' ) ;
your cursor will move accordingly to B block here.
Again u can move your cursor from B Block to A in the same way
Remember
GO_BLOCK( 'BLOCK_NAME' ) ;
simply moves your control to the specified block.
but
GO_ITEM( 'BLOCK_NAME.ITEM_NAME' ) ;
moves your control as well as cursor to the specified item. Remember that the item must be Visible and Enabled. Otherwise u will get an error message.
Hope I gave u a hint to solve your problem
Gud Luck
|
|
|
Re: NEXT BLOCK [message #315501 is a reply to message #315334] |
Mon, 21 April 2008 14:13   |
*munnabhai*
Messages: 157 Registered: March 2008 Location: Riyadh
|
Senior Member |
|
|
Hi Little,
I tried but it was same. i try to find out the problem.
the next item in the master table is not null, after inserting in the next field it works fine.
I set the property of the next item
Required = Yes it was not working
when i changed it to No it was working fine.
i dont no why this happen can anyone explain?
Regards
|
|
|
|
Re: NEXT BLOCK [message #315579 is a reply to message #315334] |
Tue, 22 April 2008 00:58   |
*munnabhai*
Messages: 157 Registered: March 2008 Location: Riyadh
|
Senior Member |
|
|
Yes little you are rite....we cannt navigate out of existing block until all required (i.e. NOT NULL) items are entered
is there any other way to do?
Regards
|
|
|
Re: NEXT BLOCK [message #315683 is a reply to message #315334] |
Tue, 22 April 2008 07:01   |
Manoj.Gupta.91
Messages: 239 Registered: March 2008 Location: Delhi
|
Senior Member |
|
|
Hi
try this
SET_FORM_PROPERTY( :SYSTEM.CURRENT_FORM, VALIDATION, PROPERTY_FALSE ) ;
it will set VALIDATION property to falase for your form.
but be careful that u set it TRUE again in order to perform default validation.
I hope it works for u
|
|
|
Re: NEXT BLOCK [message #315784 is a reply to message #315579] |
Tue, 22 April 2008 15:11  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I guess that NOT NULL constraint is here for some reason; there is (are) (a) way(s) to fool Oracle, but - are you sure you want to do that?
Finally, whatever you do in a form, you'll get an error once data is being saved into a table. Oracle will prevent you from such an operation on a database level (ORA-01400).
|
|
|