Cursor with arbitrary order

[jda]

>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
>

Hi Ruslan, I was afraid of that. Hm, can we now add temporary virtual 
fields to our records? That would make this much easier...

Jon