[V4RB] Query crash when indexed values

[Ruslan Zasukhin]

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

Hi Stan

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

ok
 
> myValue1 and myValue2 are declared that way:
> 
> myValue1 = new VByte   ("myValue1", EVFlag.fIndexed)
> myValue2 = new VUShort ("myValue2", EVFlag.fIndexed)

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

Because it will not use index.
 
> Am I using the wrong flag? or are VByte and VUShort no longer indexable?

In any case it should not crash.

Aha, why you use quotes?
Please try this 

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





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