Escaping SQL

[Bart Pietercil]

Hi Ruslan,


Could you explain why the FindLike function still accepts an  
escapestring while FindValue does not seem to need it?
Is this because internally FindLike "IS" a sqlquery ?

THX

Bart Pietercil


On 13-feb-07, at 17:25, Ruslan Zasukhin wrote:

> On 13/2/07 4:44 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:
>
> Hi Bart,
>
>> Hi List,
>>
>> it's not really clear to me whether you need to escape a string if
>> you are using the VTable.Addrecord method or if that is only
>> necessary when using the SQL syntax
>
> Only in SQL syntax, because this is needed for SQL Parser.
>
> And you need escape not the whole SQL query string,
> But only string values before concat them into query.
>
>
> -- 
> 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