[V4RB 1.98] how to escape " ' " (apostrophe) ?

[Ruslan Zasukhin]

On 5/20/04 12:06 PM, "Daniel FLEURY" <daniel.fleury at free.fr> wrote:

Hi Daniel, 

> How to search words in texts fields with apostrophe inside (exemple:
> "chercher l'apostrophe")?

Exists function ValentinaEscape()

> SQLString= "Select recID, *  from myObject WHERE myTextField LIKE
> 'chercher l'apostrophe' "
> 
> of course, in this case I find all records matching "chercher l"
> 
> but if I use backshlass to escape the ' , I find nothing:
> SQLString= "Select recID, * from myObject WHERE myTextField LIKE
> 'chercher l\'apostrophe' " -> nothing found (in Mac or XP builds)
> 
> I don't found more informations in the doc or web site. Is this a bug ?
> 
> Same problem with V4RB 1.10 but I don't use it because an encoding's bug in XP

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