Re: Developer 2000

From: Neville Sweet <sweet.neville.nj_at_bhp.com.au.no_junk_today_thanks>
Date: 1998/03/27
Message-ID: <01bd5939$d970d3e0$45f11286@itwol-pc3963.itwol.bhp.com.au>#1/1

Kishore,

In Developer 2000, set the Block 'WHERE Clause' Property to your query criteria.
Set the Form Module 'First Navigation Block' to the above block name. Add a 'When-New-Form-Instance' trigger which calls Execute_Query;

If you want to use a single form that has both the push button and displays the query results, it's just a matter of putting Execute_Query in the buttons When-Button-Pressed trigger, after ensuring that the current block is the one you want to query on (if not, use Go_Block).

Kishore Korimilli <kishore_at_com1.med.usf.edu> wrote in article <3519280E.364ABB99_at_com1.med.usf.edu>...
> Hi
> I would like to know how I can create a form based on a Query. I have a
> set of records which are the results of a Query and I want to populate
> the Form with these Records.
>
> I have a pushbutton and When the user clicks on it I want to open up
> this Form populated with the results of the Query
>
> Thanx
> Kish
>
>
>
>
Received on Fri Mar 27 1998 - 00:00:00 CST