[V4RB2] Like Statement Error

Bob Keeney bkeeney at everestkc.net
Tue May 24 17:04:55 CDT 2005


I have the following SQL statement:

Select RecID, * FROM TranscriptDetails WHERE ptrTranscript = 1 AND  
(sLineText LIKE 'them' 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?

Thanks,
Bob Keeney
BKeeney Software Inc.


More information about the Valentina mailing list