Simply SELECT problem

[Ruslan Zasukhin]

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]