[V4RB] Query crash when indexed values

[Stan Busk]

Hi,

Do you mean the ' is no longer required? Why?

> Aha, why you use quotes?
> Please try this
>
>  SELECT * FROM myTable WHERE myValue1=11 and myValue2=2005 ORDER


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?

Stan