Home » Developer & Programmer » Forms » NEXT BLOCK (Oracle Forms 6i)
NEXT BLOCK [message #315334] Mon, 21 April 2008 03:06 Go to next message
*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 #315387 is a reply to message #315334] Mon, 21 April 2008 06:33 Go to previous messageGo to next message
Littlefoot
Messages: 18828
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is your problem, exactly? Any error message? If so, which one?

As far as I can tell, if you want to navigate to another block, use GO_BLOCK('block_name'); you have used (unless I'm wrong) GO_BLOCK('block_name.item_name'). So, either remove "item_name" from the GO_BLOCK built-in, or use GO_ITEM instead.
Re: NEXT BLOCK [message #315391 is a reply to message #315334] Mon, 21 April 2008 06:43 Go to previous messageGo to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Thanks Little supporting to me....

i attached the snap of my form

im using the same go_block('block_name');
but it was going to next item

im using trigger key-next-item
go_block('block_name'); and i tried also
go_block('block_name.item_name');

the cursur going to the next record whic is procurement manager
item # 5 in the snap shot

i want the cursor should go to item # 10 as i mentioned in my snap.
how can i do this?

there is no error while compiling.

Regards


  • Attachment: forms.JPG
    (Size: 78.27KB, Downloaded 111 times)
Re: NEXT BLOCK [message #315420 is a reply to message #315391] Mon, 21 April 2008 07:54 Go to previous messageGo to next message
Littlefoot
Messages: 18828
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does
GO_ITEM('vendor_details.company_name');
do?
Re: NEXT BLOCK [message #315424 is a reply to message #315334] Mon, 21 April 2008 08:03 Go to previous messageGo to next message
Manoj.Gupta.91
Messages: 186
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 Go to previous messageGo to next message
*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 #315509 is a reply to message #315501] Mon, 21 April 2008 15:15 Go to previous messageGo to next message
Littlefoot
Messages: 18828
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It means that you can't navigate out of existing block until all required (i.e. NOT NULL) items are entered.
Re: NEXT BLOCK [message #315579 is a reply to message #315334] Tue, 22 April 2008 00:58 Go to previous messageGo to next message
*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 Go to previous messageGo to next message
Manoj.Gupta.91
Messages: 186
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 Go to previous message
Littlefoot
Messages: 18828
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).
Previous Topic: Fmb's, fmx's and compiling servers.
Next Topic: ITS URGENT NEXT MATCH WORD
Goto Forum:
  


Current Time: Sat Apr 19 03:50:56 CDT 2014

Total time taken to generate the page: 0.08679 seconds