Re: Forms3 copy() in PRE-QUERY

On Sat, 18 Jan 1997 23:47:57 +0000, Øyvind Andersen <oyvind.andersen_at_osl.ifsab.se> wrote:

>Hi!
>
>I want to perform dynamic sort order with 'desc'. The problem is that
>Oracle put's parentheses in front and after the string-value 'copy'ed to
>a block variable before executing the query so 'desc' comes inside the
>last parenthes which SQL doesn't accept.
>
>Can anyone help, please!
>
>Øyvind

An example of this technique is described in the Advanced SQL*Forms techniques version 3.0 manual under the section 'Performing Dynamic Sorting'.

Hope this helps, Lucy Received on Mon Jan 20 1997 - 00:00:00 CET