Escaping SQL

[Ruslan Zasukhin]

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]