EscapeString paramters

[Ruslan Zasukhin]

On 8/6/04 7:05 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> What is the second parameter for .EscapeString for? Since it is named
> inforRegEx I assume you should set this to true if it's a REGEX
> search, but to false if it's a regular SQL search. Is this correct?
> What does it do, exactly?

Let me remind.

Valentina 2.0 use SQL92 standard LIKE,
I.e. You can use only chars  % and _

    WHERE fld LIKE 'fff%sss _bbbb'


To get power of REGEX syntax you should use new keyword

    WHERE fld REGEX  '\Abbb'
    WHERE fld REGEXP '\Abbb'
    

For regex we need escape more symbols

        ( ) . ^ 


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------