Cursor with arbitrary order

[Ruslan Zasukhin]

On 06/27/12 6:04 PM, "jda" <jda at his.com> wrote:

> dim fld as VLong
> 
>   fld = myDatabase.myReferences.createLongField("orderField",
> EVFlag.fNone, "") //create temporary field
> 
> myCursor = myDatabase.SQLSelect("select id,orderField from
> thereferences where id in " + s, EVCursorLocation.kServerSide,
> EVLockType.kReadWrite)
> 
> ...
> enter values for orderField
> ...
> 
> myCursor = nil
> myCursor = myDatabase.SQLSelect("select * from thereferences where id
> in " + s + " ORDER BY orderField", EVCursorLocation.kServerSide,
> EVLockType.kReadOnly)
> 
> The last query gives me the same error -- field 85 doesn't exist.
> 
> If I take out the "ORDER BY orderfield" it works (but of course is useless).

You know, may be problem/bug is related to Cursors.

We use TMP fields in engine algorithms. But I think we use them without
cursors. 


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