Re: Order by on a non based column
From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 28 Feb 2002 19:47:04 GMT
Message-ID: <3C7E893D.A985E625_at_ci.seattle.wa.us>
Date: Thu, 28 Feb 2002 19:47:04 GMT
Message-ID: <3C7E893D.A985E625_at_ci.seattle.wa.us>
You probably can ... but you can also use a view. Look into INSTEAD OF triggers. They will easily solve your problem.
Daniel Morgan
Gaetan Poitras wrote:
> Hello, I forms 6i, on a block base on a table.
> I have few item that are not base on a column of the table but I which
> to do an order by on that column when I do the query on this block.
> Is it possible to find a way of doing an order by on a non-based
> column ?
>
> I don't want to use a view instead a table because I need to insert in
> that specific table.
>
> Thank you.
> Gaetan Poitras
> gpoitras_at_crcsogema.com
Received on Thu Feb 28 2002 - 20:47:04 CET