Cursor with arbitrary order

[jda]

>Yes you can.
>
>I think this is mentioned in WIKI / KERNEL

Hm, I'm trying, but get an error. Here is my  code:

fld = myDatabase.myReferences.createLongField("orderField", 
EVFlag.fTemporary, "") //create temporary field

   ...
fill in orderField for each record
...

   myCursor = myDatabase.SQLSelect("select * from thereferences where 
id in " + s + " ORDER BY orderField", EVCursorLocation.kServerSide, 
EVLockType.kReadOnly)

I get the VException: Field "85" does not exist.


Jon