Re: sort record by a non-db field, Oracle form6.0

An alternate cumbersome way is to create a record group, populate the record group with the cursor set and manipulate the record group every time you want to do an order by caluse. For Query you have to manipulate by populating the block from the record group. if the no of records is big, this might be a long process unless somebody thinks of a better process.

HTH
~Arvind Balaraman
yjmin_at_my-deja.com wrote in message <7sjdk6$ek9$1_at_nnrp1.deja.com>...
>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??
>
>Thanks very much.
>
>Eugene
>
>
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sun Sep 26 1999 - 15:04:20 CEST