[V4RB] Query crash when indexed values

Stan Busk maxprog at mac.com
Fri Nov 25 18:04:50 CST 2005


Hi,

I have the follwing query that always crash:

SELECT * FROM myTable WHERE myValue1='11' and myValue2='2005' ORDER  
BY myValue3

I use the EVCursorLocation.kServerSide, EVLockType.kNoLocks and  
EVCursorDirection.kRandom when perforing the Query.

myValue1 and myValue2 are declared that way:

myValue1 = new VByte   ("myValue1", EVFlag.fIndexed)
myValue2 = new VUShort ("myValue2", EVFlag.fIndexed)

If I remove the EVFlag.fIndexed flags, automatically the Query works.

Am I using the wrong flag? or are VByte and VUShort no longer indexable?

TIA,
~/Stan


More information about the Valentina mailing list