Re: query detail records in Oracle forms 3
From: Judy Ko -- Consultant <judy_at_gftpd-mail.citicorp.com>
Date: 27 Jan 1994 21:15:18 GMT
Message-ID: <2i9at6$727_at_charon.citicorp.com>
Date: 27 Jan 1994 21:15:18 GMT
Message-ID: <2i9at6$727_at_charon.citicorp.com>
Selina Glynn (selina_at_dciem.dnd.ca) wrote:
> The default oracle forms does not allow parameters be entered on the detail
> block. I would like to be allow users to enter values in the detail block
> to retrieve only the records that are of interest to the users. I am sure
> other people had done this. Any help or pointers will be appreciated.
If you enter field values before entering the query mode, Oracle will treat it as a new record.
You can use a form macro, entqry (?? I think) to change the mode to query mode and let the user enter the selection criteria.
I hope this may help.
Cheers,
Judy Ko.
Received on Thu Jan 27 1994 - 22:15:18 CET