Re: sort record by a non-db field, Oracle form6.0
From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Sat, 25 Sep 1999 22:08:09 GMT
Message-ID: <dJbH3.2958$rD4.33066_at_news.rdc1.nj.home.com>
Date: Sat, 25 Sep 1999 22:08:09 GMT
Message-ID: <dJbH3.2958$rD4.33066_at_news.rdc1.nj.home.com>
You could use a FROM clause query for the source and the regular table as
the destination. The right solution is to build a view, so you should try to
get
access to do that.
-- Paul Dorsey [Quoted] Dulcian, Inc. www.dulcian.com 212 595 7223 P.S. If you would like to talk to Dulcian about a salaried position on our team, please call me. We have openings in NJ for developers, in CA for PERL developers. yjmin_at_my-deja.com wrote in message <7sjdk4$ek8$1_at_nnrp1.deja.com>...Received on Sun Sep 26 1999 - 00:08:09 CEST
>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.