OraFAQ Forum: Forms » How to make block queriable

Home » Developer & Programmer » Forms » How to make block queriable (Forms 6i)

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

How to make block queriable [message #541372]

Mon, 30 January 2012 23:48

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

I have one form, when i press f7 , it says the "The function has no meaning in this context" , how to make it query enabled block.Actually i am going to that block using when button pressed and execute_query.

Report message to a moderator

Re: How to make block queriable [message #541375 is a reply to message #541372]

Tue, 31 January 2012 00:45

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

Senior Member
Account Moderator

What is the "context" in your case? All database blocks can be queried. Is that a database block, or a control block?

What is F7 mapped on your computer? Are you *sure* it is <enter query>? Check it in Help menu ("Keys").

What does "going to that block using WHEN-BUTTON-PRESSED and EXECUTE_QUERY" mean? I *know* what it means, but ... if you already are in that block and query is executed (you see some records, do you?), and F7 is out of context, well, my previous questions are raised again - what context is it and what is F7 mapped to?

Report message to a moderator

Re: How to make block queriable [message #541378 is a reply to message #541375]

Tue, 31 January 2012 00:55

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

thanks littlefoot, its a database block and i am unable to query that block."COntext" is the error messsage while querying its giving error message saying "Context has no meaning".Actually i am trying to go to a block after pressing when button pressed on the current block 'b'.I am using go_block('a') and then execute_query it displays all the records but again after retrieval, i want to go in enter_query and search that's not possible and i am getting this error message.

Report message to a moderator

Re: How to make block queriable [message #541382 is a reply to message #541378]

Tue, 31 January 2012 01:09

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

Senior Member
Account Moderator

Well, that *should* work. If you already are in a (database) block 'A' and records are displayed (after you executed EXECUTE_QUERY), then <enter query> is perfectly valid in that context.

So, are you sure that F7 is really "enter query"?

Report message to a moderator

Re: How to make block queriable [message #541384 is a reply to message #541382]

Tue, 31 January 2012 01:22

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

Yeah f7 is enter query and is there any other alternate way to do this search.

Report message to a moderator

Re: How to make block queriable [message #541388 is a reply to message #541384]

Tue, 31 January 2012 01:35

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

Senior Member
Account Moderator

What happens if you go to Query menu (while in block 'A') and select "Enter query"?

Report message to a moderator

Re: How to make block queriable [message #541390 is a reply to message #541388]

Tue, 31 January 2012 01:37

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

its goin in enter_query mode but fails to retrieve the records , but query allow property is enabled in the block.

Report message to a moderator

Re: How to make block queriable [message #541395 is a reply to message #541390]

Tue, 31 January 2012 01:47

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

Senior Member
Account Moderator

Wait a second ... "enter query" doesn't retrieve anything, it only lets you enter search criteria and then, when you press "execute query", records that satisfy these criteria are retrieved.

Report message to a moderator

Re: How to make block queriable [message #541399 is a reply to message #541395]

Tue, 31 January 2012 02:03

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

I mean't i tried both the option , opened another block in enter query and added the search criteria and queried it did'nt work.Is there a work around for this , i am attaching my fmb where there is a block ip_rep_info where there is a field PB_EMP, from there i am goin to "ov_emp" block and there i want to search based on criteria.

Attachment: OD6029_05_W.fmb
(Size: 972.00KB, Downloaded 1065 times)

Report message to a moderator

Re: How to make block queriable [message #541413 is a reply to message #541399]

Tue, 31 January 2012 02:39

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

Senior Member
Account Moderator

OK, so OV_EMP block is a database block, based on EMP_VIEW and query is allowed on that block. There are no block-level triggers there. I searched the form's PL/SQL for "ov_emp" (thinking that there might be SET_BLOCK_PROPERTY somewhere, but - nope, didn't find any).

At the moment, I have no idea why "enter query" / "execute query" wouldn't work on that block (except if no records satisfy criteria you entered, but that wouldn't raise "The function has no meaning in this context". Hopefully, someone else will know better.

Report message to a moderator

Re: How to make block queriable [message #541424 is a reply to message #541413]

Tue, 31 January 2012 03:37

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

Senior Member

Where exactly is the cursor when you press f7?
Are you sure emp_view returns data? Try querying it in sqlplus.

Report message to a moderator

Re: How to make block queriable [message #541433 is a reply to message #541424]

Tue, 31 January 2012 04:18

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

yes , it retrieves data in sql plus and kindly see the attached fmb also.

Report message to a moderator

Re: How to make block queriable [message #541434 is a reply to message #541433]

Tue, 31 January 2012 04:24

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

Senior Member

I have seen the fmb. I see no obvious reason for the problem. I suggest you trace the form session in the database and see what it's really doing.

Report message to a moderator

Previous Topic:	Can migrating oracle 6i into oracle 11g?
Next Topic:	how to bind hierarchy tree items to text items and other items?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 15 17:51:03 CDT 2024