OraFAQ Forum: Forms » Its Urgent About Execute

Home » Developer & Programmer » Forms » Its Urgent About Execute_Query?

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

Its Urgent About Execute_Query? [message #82557]

Mon, 09 June 2003 01:07

Anand Chiney
Messages: 7
Registered: April 2003

Junior Member

Hello

I have developed a form containing two blocks.
One block (master) "Book", contains the Book Category
(such as computers, economics, history etc). User can select
the categories using LOV.
The other block (Detail) "Information" should display
the bookID, BookName, Author and AvailabiltyStatus of
all the books as per the selection of Book Category.
What i have done with the detail block is, taken
a tabular form and set the Records Displayed to 20 with
scrollbar. Each book category is having atleast 100 books.

Using the DEFAULT Menu Bar, I have done it.
Know how to display all the records in the tabular form
block after selecting the Book Category (without using the
Execute from the Default Menu bar) ?

I WANT THIS TO OCCUR ON WHEN-VALIDATE-ITEM TRIGGER OF THE
TEXT ITEM CONTAINING THE BOOK CATEGORY OR ON THE WHEN-BUTTON-PRESSED TRIGGER
OF ANY BUUTON.
How to do this ?

Thks in advance

Report message to a moderator

Re: Its Urgent About Execute_Query? [message #82561 is a reply to message #82557]

Tue, 10 June 2003 00:01

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Here's one example:

If there's a relationship between the two blocks in Forms, make sure that the property "deferred" is set to "No". In the WHEN-VALIDATE-ITEM, you cannot use restricted built-ins, so you'll have to look for another trigger: KEY-LISTVAL is one possibility. In the KEY-LISTVAL, make sure you do the default action first (showing LOV) with the built-in LIST_VALUES;, after that you simply issue the EXECUTE_QUERY; built-in. The non-deferred property of the relationship makes sure that the Detail records are fetched too.

If the "deferred" property is set to "yes", you have to navigate to the detail block ('go_Block') before executing the query.

BTW: It's always "urgent", stop including that in the subject line. Words like that act as a very effective "answer-repellent".

MHE

Report message to a moderator

Re: Its Urgent About Execute_Query? [message #82573 is a reply to message #82561]

Tue, 10 June 2003 07:21

Anand Chiney
Messages: 7
Registered: April 2003

Junior Member

Hi Maaher

Thks for the answer.
It was urgent thats why i have included. Till this one
i have never used the word URGENT in this forum
well thks again

Report message to a moderator

Previous Topic:	Converting Forms 3.0 to Forms 6.0
Next Topic:	LOCKING PROBLEM IN DEVELOPER 2000 APPLICATION

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 19 05:44:26 CST 2025