Simply SELECT problem -- fixed

[Bill Mounce]

That fixed the problem. Thanks. What might I have done to cause the  
need for reindexing? I did not change the length of any indexed  
field, nor did I add a new indexed field.

Bill


On Sep 28, 2005, at 11:01 PM, Ruslan Zasukhin wrote:

> On 9/29/05 8:56 AM, "Bill Mounce" <BillMounce at Comcast.net> wrote:
>
> Hi Bill,
>
>
>> This feels silly since it is so basic, but I can't get the following
>> to work, and I know there is a record with the value of 686 in the
>> field GK. Any ideas as to what is preventing the select? The database
>> is open. I am on 2.0.5 AND RB 2005(3).
>>
>>
>>          tGK = "686"
>>          tSQL = "select * from HEBREW where GK = '" + tGK + "'"
>>          mHebrewCursor = mHebrewDataBase.SQLselect( tSQL, _
>>          EVCursorLocation.kServerSide, EVLockType.kReadWrite,
>> EVCursorDirection.kRandom )
>>
>
> TGK is string field ?
>
> All looks correct. Try reindex database
>
>
> -- 
> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>