Re: Developer 2000 Forms order by clause

Another solution:
[Quoted] If that display field can be populated from base table column(s) then it should be possible to write a db function with such base table column(s) used as input params and return the value for the display field. After that you can freely add order clause for the block like that:

order by function_name(column1,column2)

HTH In article <8fshpk$7ve$1_at_nnrp1.deja.com>,   Luis Cabral <luiscabral_at_starmedia.com> wrote:
> Hello
>
> I think it is not possible, you can only order by
> columns of the table itself (even if they do not appear
> in the form). One solution is creating a updateable
> view that includes the lookup column, and base the
> block in that view. Then you can order by the lookup
> column.
>
> In article <8fsh6f$7a1$1_at_nnrp1.deja.com>,
> ssharma24_at_my-deja.com wrote:
> > Developer 2000 Forms order by clause:
> >
> > How do you sort some thing based on a field that is a “display
 field”
> > And it’s not a database field, it’s getting populated by a post
 querry
> > trigger
> > What clause do you put in order by property
> >
> > I also have some “text item” fields that are non database fields
> > getting populated by an LOV or a post querry trigger.
> >
> > In either case, can you sort based on fields like that…if yes
 how?????
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 17 2000 - 00:00:00 CEST