Home » Developer & Programmer » Forms » Its Urgent About Execute_Query?
Its Urgent About Execute_Query? [message #82557] Mon, 09 June 2003 01:07 Go to next message
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
Re: Its Urgent About Execute_Query? [message #82561 is a reply to message #82557] Tue, 10 June 2003 00:01 Go to previous messageGo to next message
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
Re: Its Urgent About Execute_Query? [message #82573 is a reply to message #82561] Tue, 10 June 2003 07:21 Go to previous message
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
Previous Topic: Converting Forms 3.0 to Forms 6.0
Next Topic: LOCKING PROBLEM IN DEVELOPER 2000 APPLICATION
Goto Forum:
  


Current Time: Thu Mar 28 11:53:45 CDT 2024