EscapeString paramters

[Ruslan Zasukhin]

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

>> In the SQL folders you can find example Binding.
>> 
> 
> Hm, I don't see how I would use this for searching indexes
> indexedbyword. But it does bring up a question about .escsapescring:
> 
> If I do a SQL search of an indexed (by word) field, it's for the name
> O'Shea, would I first
> 
> s = Valentina.EscapeString("O'Shea", false)

Yes, because you will need build SQL string of query which looks

    "...WHERE fld = 'O\'Shea'
                      ^^^^

If you will not have ESCAPE on apostrophe, then how parser can know that
this apostrof is not the end of string constant? You see?

 
> and if it's a Valentina REGEX search
> 
> s = Valentina.EscapeString("O'Shea", true)
> 
> And what would I do for a SQL LIKE search?

Also 

   s = Valentina.EscapeString("O'Shea", false)

> I guess I'm asking how V2.0 is going to handle indexes...

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