OraFAQ Forum: Forms » ENTER QUERY MODE

Home » Developer & Programmer » Forms » ENTER QUERY MODE (

) 1 Vote

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

ENTER QUERY MODE [message #622516]

Wed, 27 August 2014 05:28

Mayur Shinde
Messages: 60
Registered: August 2014
Location: Pune, Maharashtra

Member

I AM INSERTING DISTRICT NAME INTO TABLE DISTRICT MASTER. BEFORE THAT I AM FETCHING STATE NAME AND DISTRICT CODE FROM STATE MASTER. NOW, MY REQUIREMENT IS HOW TO DO LIKE OPERATION ON STATE CODE. i.e. AFTER ENTERING '0' IN STATE CODE IT WILL SHOW ALL STATES STARTING FROM '0' ALONG WITH DISTRICT DETAILS.

KINDLY HELP ME.

Report message to a moderator

Re: ENTER QUERY MODE [message #622519 is a reply to message #622516]

Wed, 27 August 2014 05:31

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Welcome to the forum!

Please read and follow the forum guidelines, to enable us to help you: http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Please do NOT post in uppercase, it is considered as shouting in forum.

Report message to a moderator

Re: ENTER QUERY MODE [message #622521 is a reply to message #622519]

Wed, 27 August 2014 06:01

Mayur Shinde
Messages: 60
Registered: August 2014
Location: Pune, Maharashtra

Member

I really apologies for the past post.

Report message to a moderator

Re: ENTER QUERY MODE [message #622522 is a reply to message #622521]

Wed, 27 August 2014 06:09

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

Senior Member
Account Moderator

The simplest option (from my point of view) is to create a list of values (LoV). First create its record group query and a list of values based on that query. Map LoV fields with block items. Basically, wizard is capable of doing it all, just read it carefully and it'll be OK.

When you run the form and set focus to state code item, open LoV. It will enable you to search for any values you are interested in (including the ones whose state code begins with '0'). Pick one value, push the <OK> button and that would be all.

Report message to a moderator

Re: ENTER QUERY MODE [message #622525 is a reply to message #622522]

Wed, 27 August 2014 06:42

Mayur Shinde
Messages: 60
Registered: August 2014
Location: Pune, Maharashtra

Member

Thank you...!
It is working fine...!
But instead of showing result in LOV; I would like to display result in the same form. i.e. my task is working of (Ctrl + F11) shortcut key.

Report message to a moderator

Re: ENTER QUERY MODE [message #622526 is a reply to message #622525]

Wed, 27 August 2014 06:45

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

Senior Member
Account Moderator

I see ... I, somehow, thought that you want to search for some values while entering new records.

OK then, when you enter query mode, put

0%

(zero and percent sign, which is a wildcard character) into the state code item. Then execute query. All records whose state code begins with 0 will be displayed.

Report message to a moderator

Re: ENTER QUERY MODE [message #622595 is a reply to message #622526]

Wed, 27 August 2014 23:26

Mayur Shinde
Messages: 60
Registered: August 2014
Location: Pune, Maharashtra

Member

Hi All,
On "WHEN-BUTTON_PRESSED" trigger :
1. How to check current operation mode.
2. How to change it.
3. If current operation mode is enter query then how to fire a query.

Please suggest me..

Thank you.

Report message to a moderator

Re: ENTER QUERY MODE [message #622600 is a reply to message #622595]

Thu, 28 August 2014 01:18

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

Senior Member
Account Moderator

See :SYSTEM.FORM_STATUS and/or check GET_RECORD_PROPERTY built-in in Forms Help
SET_RECORD_PROPERTY can modify record status (if that's what you are asking)
Use EXECUTE_QUERY

Report message to a moderator

Previous Topic:	concurrency
Next Topic:	ENTER QUERY MODE NOT MOVE CURSOR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 04:55:59 CDT 2024