Re: sort record by a non-db field, Oracle form6.0
Date: Sun, 26 Sep 1999 15:16:19 GMT
Message-ID: <7NqH3.44$dB1.4548_at_nntp.csufresno.edu>
The standard way is to create a stored function to return the value you want to sort on, and use the function in the order by clause of your select.
To use your cursor to populate the block, you need to specify your base-table in the block's properties. There may be other things too, I am not sure. But I know it can be done.
Steve Cosner
In article <7sjdk4$ek8$1_at_nnrp1.deja.com>, <yjmin_at_my-deja.com> wrote:
>Oracle form6.0,
>Can anyone help me out to sort records in a block
>by a non-database field (field with the table
>other than block's base table)?
>I created a cursor to populate the fields
>including block's ROWID field and then set record
>staus to Query, through this way I try to imitate
>the querying records as if retrieved by Oracle
>default query process. But when I go back to
>block to update/delete records, some gave error
>FRM-40654.
>I guess that use view as block's base source may
>work but I am not authorized to create view.
>Any other ideas??
Received on Sun Sep 26 1999 - 17:16:19 CEST