Re: How to populate blocks in F4.5
From: Walter Zimmer <wzimmer_at_atair.rz.uni-ulm.de>
Date: 1997/04/25
Message-ID: <5jpu81$j9f$3_at_orion-fddi.rz.uni-ulm.de>#1/1
Date: 1997/04/25
Message-ID: <5jpu81$j9f$3_at_orion-fddi.rz.uni-ulm.de>#1/1
Neal (nealgran_at_erols.com) wrote:
: I want to populate a Forms 4.5 block with data using a query that cannot
: be specified simply by using the Where and Order by properties of the
: block. The problem is that the query is based on a field in a cross
: reference table which is a child of the table of that block.
ANY query can be specified in the where clause !
I use the following where clause:
SET_BLOCK_PROPERTY('NSDB_GERAET', DEFAULT_WHERE,
'id in select something FROM anything');
This query selects all rows with the ids that you determine with the SELECT, which can be anything you want.
Walter
walter.zimmer_at_rz.uni-ulm.de
Forms 4.5.7.1.2 developer (solaris, NT)
Received on Fri Apr 25 1997 - 00:00:00 CEST