V4MD escape apostrophe

[Ruslan Zasukhin]

On 6/19/05 1:55 PM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

> Hi all
> 
> If I search a string like "DALL'OSTO" I get this:
> ERROR: ERR_SQL_PARSER_ERROR(line 1:1: unsexpected token:DALL)

    LIKE 'string'

Must be single quotes
And you need escape quote:

    LIKE 'DALL\'OSTO'


> my query is:
> query = "SELECT RecID, * from" && gTableName &&\
> "WHERE '" & searchString & "' IN" && member("fieldNameList").text
> gCursor = gDb.sqlSelect(query, #kServer, gLockType, #kRandom)
> 
> I read in the docs that is necessary to ESCAPE the apostrophe,
> but I don't know how to insert the ESCAPE expression in my query.

For this you can use Valentina.EscapeString() method

> Can somebody help me, please?
> 
> Sorry if the question is old for others members list...

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