Re: Sorting on non-base table items in Forms 4.5
Date: 17 Jul 1998 21:31:57 GMT
Message-ID: <6oofsd$ri92_at_hendrix.csufresno.edu>
To order your base table block on a non-base-table item, create a stored function that returns the value you want to use to sort. Then set your order-by clause for the base-table block to use the function:
My_Function(Column_X)
(You can look up other explanations of this method on Deja News: www.dejanews.com. Go to "power search", and search for author SmithM_at_logica.com, date: 1997/05/30)
Steve Cosner
In article <6ok21e$9d3$1_at_nnrp1.dejanews.com>, <dan_at_chowd.com> wrote:
>Does anyone know how to sort a block on a non-base table item in Forms 4.5? I
>don't want to use a view, since I want the block to be updatable.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Jul 17 1998 - 23:31:57 CEST