OraFAQ Forum: Forms » getting data after pressing TAB in INSERT MODE in Forms 10g

Home » Developer & Programmer » Forms » getting data after pressing TAB in INSERT MODE in Forms 10g (D2K 10g)

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

getting data after pressing TAB in INSERT MODE in Forms 10g [message #482082]

Tue, 09 November 2010 07:45

ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore

Member

What to write in a form for getting data after pressing TAB in 'ENTER-QUERY' MODE on a field having a LOV i.e. a trigger/program unit or what?

Kindly write/provide the info

[Updated on: Tue, 09 November 2010 07:49]

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482083 is a reply to message #482082]

Tue, 09 November 2010 07:49

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

Senior Member

Get what data from where?

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482084 is a reply to message #482083]

Tue, 09 November 2010 07:50

ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore

Member

I have updated the question.

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482085 is a reply to message #482082]

Tue, 09 November 2010 07:51

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, you should "get data" by executing a query. If you insist on <TAB> key, then you could try with KEY-NEXT-ITEM trigger (which is what <TAB> does):

EXECUTE_QUERY;

This might, or might not work smoothly (as there might be "Do you want to save changes?" message if you already changed the current record. Or you might first set focus to a database block (if it is a control block you are in). Or ...).

Maybe you should explain what you are trying to do, using more words (it's not that you are charged by number of characters you type, are you?).

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482086 is a reply to message #482084]

Tue, 09 November 2010 07:56

ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore

Member

Actually I am having a FORM in 10g in which if I use INSERT MODE and press TAB on a field which is having a LOV then all data gets popped up. There is a property in property palette which is Validate from List which it is set to YES .

Now I want to display the records in ENTER QUERY MODE also. By default in ENTER QUERY MODE this property gets set to FALSE/NO.
I hope this clarifies the question.

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482089 is a reply to message #482086]

Tue, 09 November 2010 08:02

ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore

Member

I have attached the doc also Sad

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482091 is a reply to message #482089]

Tue, 09 November 2010 08:13

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

Senior Member

So you want to display an LOV automatically in ENTER-QUERY mode?
Was that really that difficult to say?

Validate from list never kicks in in enter-query mode. For the same reason when-validate-item triggers never fire in enter-query mode.
You can make the LOV appear by calling the LIST_VALUES built in from the Key-next-item trigger.

EDIT: added an in

[Updated on: Tue, 09 November 2010 08:14]

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482127 is a reply to message #482091]

Tue, 09 November 2010 21:49

ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore

Member

Thanks Friend! Actually I am not really in touch of D2K. So probably I use more words to explain. Surely I will improve on this as my experience grows

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482128 is a reply to message #482127]

Tue, 09 November 2010 21:54

ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore

Member

Thanks Fried. It really worked for me. May I have your email id so that in future I can contact you for D2K related issues

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482129 is a reply to message #482128]

Tue, 09 November 2010 22:01

ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore

Member

Dear Friend I tried with the following code in KEY-NEXT-ITEM trigger earlier. It did not work. What is the issue with this?

set_ITEM_property('EMPLOYER_DETAIL.COMPANY_NAME',lov_name,'LOV_INSURED');
set_ITEM_property('EMPLOYER_DETAIL.COMPANY_NAME',validate_from_list,property_true);

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482134 is a reply to message #482129]

Wed, 10 November 2010 00:08

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why did you use SET_ITEM_PROPERTY? It is used when you have to set certain properties during runtime. As of your case, you could have done that in COMPANY_NAME item's property palette.

Besides, "calling the LIST_VALUES built in from the Key-next-item trigger" (which is what Cookiemonster said) is something completely different from what you've done. He said that you should use LIST_VALUES built-in, not SET_ITEM_PROPERTY.

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482153 is a reply to message #482091]

Wed, 10 November 2010 01:47

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

Senior Member

cookiemonster wrote on Tue, 09 November 2010 14:13

Validate from list never kicks in in enter-query mode. For the same reason when-validate-item triggers never fire in enter-query mode.

I meant what I said. There is no point trying to switch on validate from list in enter-query mode. It does nothing in that mode.
I suggest you try following the clear instructions I actually gave.

Report message to a moderator

Re: getting data after pressing TAB in INSERT MODE in Forms 10g [message #482160 is a reply to message #482153]

Wed, 10 November 2010 03:22

ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore

Member

Thanks Cookiemonster I have done it already. Thanks for clsrifying my doubts!! Cool

Report message to a moderator

Previous Topic:	oracle forms30 (merged)
Next Topic:	Restrict field after insertion before commit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 00:21:06 CDT 2024