Re: FROM clause query in Forms 6
Date: Mon, 12 Jul 1999 10:09:32 +0800
Message-ID: <37894E5C.EBCAB18C_at_ccis.adisys.com.au>
deleona_at_my-deja.com wrote:
> Does anyone know how to use a FROM clause query as a datasource for a
> datablock? I manually created a datablock. I set the 'Query Data
> Source Type' property to 'FROM clause query'. I set the 'Query Data
> Source Name' to the SELECT statement that I want to use to populate the
> datablock. Where do I go from here? How do I assign the values from
> the select to the datablocks items to be displayed?
>
Name the items in your block the same as the columns in your select statement and Oracle magic will do the rest.
HTH
Geoff
> Any help would be appreciated greatly! Thanks in advance!
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jul 12 1999 - 04:09:32 CEST