OraFAQ Forum: Forms » after clear the filed , goes at the first column

Home » Developer & Programmer » Forms » after clear the filed , goes at the first column

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

after clear the filed , goes at the first column [message #607122]

Mon, 03 February 2014 01:58

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

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607124 is a reply to message #607122]

Mon, 03 February 2014 02:01

Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad

Junior Member

Set your previous & next navigation properties in the item..

Hope it works.

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607138 is a reply to message #607124]

Mon, 03 February 2014 04:28

Littlefoot
Messages: 21823
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 (?!?).

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607139 is a reply to message #607138]

Mon, 03 February 2014 04:34

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.

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607141 is a reply to message #607122]

Mon, 03 February 2014 05:05

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.
/forum/fa/11657/0/

Attachment: image1.png
(Size: 3.10KB, Downloaded 6266 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

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

Senior Member

So what code does the clear button actually run?

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607146 is a reply to message #607144]

Mon, 03 February 2014 05:26

mist598
Messages: 1195
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

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607147 is a reply to message #607144]

Mon, 03 February 2014 05:30

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

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607148 is a reply to message #607122]

Mon, 03 February 2014 05:33

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

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607149 is a reply to message #607147]

Mon, 03 February 2014 05:33

cookiemonster
Messages: 13963
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?

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607150 is a reply to message #607149]

Mon, 03 February 2014 05:37

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.

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607152 is a reply to message #607122]

Mon, 03 February 2014 05:49

Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad

Junior Member

Ok leave it please.

How to fix that problem please explain me.

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607162 is a reply to message #607152]

Mon, 03 February 2014 06:16

Littlefoot
Messages: 21823
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

mughals_king
Messages: 392
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

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

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607229 is a reply to message #607213]

Tue, 04 February 2014 02:06

mist598
Messages: 1195
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

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607232 is a reply to message #607229]

Tue, 04 February 2014 02:17

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.

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607239 is a reply to message #607122]

Tue, 04 February 2014 03:16

Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad

Junior Member

Can any one please help me on this.

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607241 is a reply to message #607239]

Tue, 04 February 2014 03:38

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607263 is a reply to message #607241]

Tue, 04 February 2014 05:14

mughals_king
Messages: 392
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

Report message to a moderator

Re: after clear the filed , goes at the first column [message #607264 is a reply to message #607263]

Tue, 04 February 2014 05:27

mughals_king
Messages: 392
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

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)

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 13:02:41 CST 2025