[V4RB] Query crash when indexed values

[Ruslan Zasukhin]

On 11/25/05 10:09 PM, "Stan Busk" <maxprog at mac.com> wrote:


May be try REINDEX your db ?
Or test on fresh ?

> Also, I have a crash here:
> 
> aCursor = myDatabase.SQLselect("SELECT myTable_Field FROM myTable
> ORDER BY myTable_Date DESC", EVCursorLocation.kServerSide,
> EVLockType.kNoLocks, EVCursorDirection.kRandom)
> 
> It always crash. However:
> 
> aCursor = myDatabase.SQLselect("SELECT myTable_Field,myTable_Date
> FROM myTable ORDER BY myTable_Date DESC",
> EVCursorLocation.kServerSide, EVLockType.kNoLocks,
> EVCursorDirection.kRandom)
> 
> works. Seems I can no longer SELECT a particular field without
> including the field I order with.
> 
> Am I right?

Yes this is correct.

SQL92 require that you can ORDER BY only on field which is SELECTed


Ivan, but we should not crash in first case also.
Strange, I believe we have such tests. Please put on TODO


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