[V4RB2] Like Statement Error

[Ruslan Zasukhin]

On 5/25/05 1:04 AM, "Bob Keeney" <bkeeney at everestkc.net> wrote:

> I have the following SQL statement:
> 
> Select RecID, * FROM TranscriptDetails WHERE ptrTranscript = 1 AND
> (sLineText LIKE 'them' no_case)

Valentina 2 do not support keywrod  no_case
 
> I put the sql in the following piece of code:
> mSearchCursor = gDB.SQLselect( s, EVCursorLocation.kClientSide,
> EVLockType.kNoLocks, EVCursorDirection.kRandom  )
> 
> I receive the following error:
> Error: 462848:  Line 1:1:  unexpected token: them
> 
> I don't see anything obvious in the SQL and this worked perfectly in
> 1.1.  Any ideas?

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