Re: Sorting on non-base table items in Forms 4.5
From: Allan Griffith <allan.griffith_at_stir.ac.uk>
Date: Thu, 16 Jul 1998 13:33:37 +0100
Message-ID: <35ADF321.1F1F_at_stir.ac.uk>
Date: Thu, 16 Jul 1998 13:33:37 +0100
Message-ID: <35ADF321.1F1F_at_stir.ac.uk>
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
Dan
Use a function stored on the database which returns the value of the field you wish to sort on.
Then enter the function in the block's ORDER BY clause.
eg valueOf(valueId)
Hope this helps
Allan Received on Thu Jul 16 1998 - 14:33:37 CEST