Re: Block based on a query with Forms 5
From: Geoff White <whiteg_at_ccis.adisys.com.au>
Date: Wed, 10 Feb 1999 10:51:53 +0800
Message-ID: <36C0F449.35365675_at_ccis.adisys.com.au>
Date: Wed, 10 Feb 1999 10:51:53 +0800
Message-ID: <36C0F449.35365675_at_ccis.adisys.com.au>
Karim KOLLI - Pascale BERTONI wrote:
> How can I create a block based on a query with Forms 5.
> My query is based on severals differents tables.
> My block needs only to be in consulting mode.
>
> thank you for your help.
>
> Pascale.
A way to do this is to use the 'From Clause query' option in the Query Data Source Type under the Database section of the Property Palette. In the Query Data Source Name you then write your query. One thing you can't do is pass a form item as a parameter in the where clause of your query.
HTH Geoff Received on Wed Feb 10 1999 - 03:51:53 CET