Cursor with arbitrary order

[Ruslan Zasukhin]

On 06/27/12 12:13 AM, "jda" <jda at his.com> wrote:

> Hi,
> 
> I want to create a cursor where the results reflect an arbitrary
> order (e.g. the user chose object from a list in this order: 9, 2, 5,
> 1. I'm doing a select for records which have an id (integer field) in
> (9,2,5,1). But of course they come back ordered by value. Is there an
> easy way to do what I want?

No Jon,

This is not so easy task.

You need manage self special additional field, e.g. Position
You need self manage changes of values of this field.

And to get items in YOUR OWN order you will do
    
    SELECT ...
    ORDER BY Position


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]