Home » Developer & Programmer » Forms » after clear the filed , goes at the first column
after clear the filed , goes at the first column [message #607122] Mon, 03 February 2014 01:58 Go to next message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Hi all,

After i selected the lov & click on the clear button , it clears that filed & went to the 1st column , for this i want clear the column& stay with that column only , how to set this in form?

Thank You
Re: after clear the filed , goes at the first column [message #607124 is a reply to message #607122] Mon, 03 February 2014 02:01 Go to previous messageGo to next message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Set your previous & next navigation properties in the item..

Hope it works.
Re: after clear the filed , goes at the first column [message #607138 is a reply to message #607124] Mon, 03 February 2014 04:28 Go to previous messageGo to next message
Littlefoot
Messages: 19901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't get it ... it seems that you replied to yourself, but aren't sure that it'll work (?!?).
Re: after clear the filed , goes at the first column [message #607139 is a reply to message #607138] Mon, 03 February 2014 04:34 Go to previous messageGo to next message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Quote:
I don't get it ... it seems that you replied to yourself, but aren't sure that it'll work (?!?).


This is mistake Littlefoot sorry for that..

And it is not worked for me, Can you please suggest me.
Re: after clear the filed , goes at the first column [message #607141 is a reply to message #607122] Mon, 03 February 2014 05:05 Go to previous messageGo to next message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Hi sir,

Please find the below sample screen shot & let me help plz.Why the cursor blink in the first column.It also , when if click on the clear button , it clears the Deptno & Goes to DNAME Field , i want to show the cursor even , clear the Deptno field.

This is my sample screen shot only, i used in the Oracle Apps Forms Server.
./fa/11657/0/
  • Attachment: image1.png
    (Size: 3.10KB, Downloaded 464 times)

[Updated on: Mon, 03 February 2014 05:06]

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607144 is a reply to message #607141] Mon, 03 February 2014 05:22 Go to previous messageGo to next message
cookiemonster
Messages: 11287
Registered: September 2008
Location: Rainy Manchester
Senior Member
So what code does the clear button actually run?
Re: after clear the filed , goes at the first column [message #607146 is a reply to message #607144] Mon, 03 February 2014 05:26 Go to previous messageGo to next message
mist598
Messages: 1064
Registered: February 2013
Location: Hyderabad
Senior Member
Hi sir,

i wrote in the Clear Button app_find.clear, it clears only the Dname , Deptno fields only i wanted
Re: after clear the filed , goes at the first column [message #607147 is a reply to message #607144] Mon, 03 February 2014 05:30 Go to previous messageGo to next message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Hi cookiemonster, why the replied form other people users id, i can't Believe this
Re: after clear the filed , goes at the first column [message #607148 is a reply to message #607122] Mon, 03 February 2014 05:33 Go to previous messageGo to next message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Quote:
So what code does the clear button actually run?

i wrote in the Clear Button app_find.clear, it clears only the Dname , Deptno fields only i wanted
Re: after clear the filed , goes at the first column [message #607149 is a reply to message #607147] Mon, 03 February 2014 05:33 Go to previous messageGo to next message
cookiemonster
Messages: 11287
Registered: September 2008
Location: Rainy Manchester
Senior Member
Are you saying that you Rajesh wrote the post above this listed as being written by mist598?
Re: after clear the filed , goes at the first column [message #607150 is a reply to message #607149] Mon, 03 February 2014 05:37 Go to previous messageGo to next message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Quote:
Are you saying that you Rajesh wrote the post above this listed as being written by mist598?


Yes sir you are right. But how it is possible? I have user name with Rajesh@ , i am using from Net(Net Cafe) like pay& use.
Re: after clear the filed , goes at the first column [message #607152 is a reply to message #607122] Mon, 03 February 2014 05:49 Go to previous messageGo to next message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Ok leave it please.

How to fix that problem please explain me.
Re: after clear the filed , goes at the first column [message #607162 is a reply to message #607152] Mon, 03 February 2014 06:16 Go to previous messageGo to next message
Littlefoot
Messages: 19901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know Oracle Apps.

What does APP_FIND.CLEAR do? It seems that it works as if CLEAR_BLOCK has been executed (but you want to do ... what? CLEAR_ITEM?). Is there any other APP_FIND.CLEAR_... procedure you could use (or, maybe, provide additional parameters to the current procedure)?

[Updated on: Mon, 03 February 2014 06:16]

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607202 is a reply to message #607162] Mon, 03 February 2014 13:46 Go to previous messageGo to next message
mughals_king
Messages: 390
Registered: January 2012
Location: pakistan
Senior Member
Try this frnd

APP_FIND.CLEAR_DETAIL('MYBLOCK');


app_find.clear;
go_block('blockname');


make sure Whether "GO_BLOCK" will work before app_find.clear OR after.

May be could work for you

Regard
Mughal

[Updated on: Mon, 03 February 2014 14:02]

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607213 is a reply to message #607202] Mon, 03 February 2014 22:27 Go to previous messageGo to next message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Hi Mughals,

I tried with the below codes , but both worked as the same.Any Another code you have let me know please.

Thank You
Re: after clear the filed , goes at the first column [message #607229 is a reply to message #607213] Tue, 04 February 2014 02:06 Go to previous messageGo to next message
mist598
Messages: 1064
Registered: February 2013
Location: Hyderabad
Senior Member
Hi Rajesh,

You have to write some code in all text items like post text item or when-validate-item trigger you can add :global.goitem := :SYSTEM.CURRENT_ITEM;

When you pressed find button it will go to database block from there you are pressing back button to come find block right. So can you please put GO_ITEM(:global.goitem); this code in back button from database block

You get the solution surely.. Smile
Re: after clear the filed , goes at the first column [message #607232 is a reply to message #607229] Tue, 04 February 2014 02:17 Go to previous messageGo to next message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Hi mist598,

I got the soution, but why the cursor point goes into the 1st item in the find window canvas after i cleared that item , using clear button.Can please suggest.
Re: after clear the filed , goes at the first column [message #607239 is a reply to message #607122] Tue, 04 February 2014 03:16 Go to previous messageGo to next message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Can any one please help me on this.
Re: after clear the filed , goes at the first column [message #607241 is a reply to message #607239] Tue, 04 February 2014 03:38 Go to previous messageGo to next message
Littlefoot
Messages: 19901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What "help"? You said that you got the solution.




It seems that you use a procedure (such as APP_FIND.CLEAR), but you have no idea what it exactly does. Do you? I doubt, because you wouldn't ask such questions here. The rest I meant to say is already written in a message #607162.
Re: after clear the filed , goes at the first column [message #607263 is a reply to message #607241] Tue, 04 February 2014 05:14 Go to previous messageGo to next message
mughals_king
Messages: 390
Registered: January 2012
Location: pakistan
Senior Member
Dear read documents 1st what exactly APP_FIND_CLEAR Does. you already asked this question to OTN Community as well.

Trigger WHEN_BUTTON_PRESSED APP_FIND.CLEAR;
CLEAR (Button Item) Trigger

APP_FIND.CLEAR
Variable 	Description

procedure  APP_FIND.CLEAR;

Description 	This routine is called by the "Clear" button in a Find Window to clear the Find Window.

APP_FIND.CLEAR_DETAIL
Variable 	Description

procedure  APP_FIND.CLEAR_DETAIL(

detail_block    varchar2);

Description 	This routine clears the result block of a find block (not a Find window). This action can only be performed from triggers that allow navigation.

Variable 	Description

detail_block 	The name of the block to be cleared




https://community.oracle.com/message/12237520

http://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T462355.htm

http://www.slideshare.net/ManuMK1/oracle-appstechnicaltutorial121011130201phpapp02


Regard
mughal

Re: after clear the filed , goes at the first column [message #607264 is a reply to message #607263] Tue, 04 February 2014 05:27 Go to previous messageGo to next message
mughals_king
Messages: 390
Registered: January 2012
Location: pakistan
Senior Member

Trigger WHEN-BUTTON-PRESSED

APP_FIND.CLEAR;

KEY_NXTBLK(BLOCK LEVEL TRIGGER)

CLEAR(Button Item)



Read below link more steps would be clear.

http://oracleapps88.blogspot.com/2012/07/oracle-applications-11i_29.html


Hope something would be clear.

Regard
Mughal



[Updated on: Tue, 04 February 2014 05:28]

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607265 is a reply to message #607264] Tue, 04 February 2014 05:32 Go to previous message
Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad
Junior Member
Hi Mughal,

I have written the default where condition.where to write the below code in the find button.Please help me on this
1) how to write KEY_NXTBLK(BLOCK LEVEL TRIGGER)
2)CLEAR(Button Item)
Previous Topic: download forms and report 10g 64 bit for windows 7
Next Topic: ora-12514 TNS:listener does not currently know of service
Goto Forum:
  


Current Time: Sun Dec 28 17:01:26 CST 2014

Total time taken to generate the page: 0.09927 seconds