V4MD

[Ruslan Zasukhin]

On 3/4/05 4:20 PM, "laurent lacoste" <laurent.lacoste at actus.net> wrote:

> Yes my string have single quotes
> my code :
> 
> global mamarqvehi,modelevehi
> 
> set SQLstring to "Select distinct modele from vehicule WHERE marque str_fld
> LIKE "&&"'\A"&mamarq&"\Z'"&&"no_case"

Aha!

I see where is problem!

You use LIKE search.
Which actually in Valentina 1.x is REGEX search.

REGEX use () as control chars.

So you must at first Escape string mamarq


 LIKE "&&"'\A"& ValentinaEscape(mamarq ) &"\Z'"&&"no_case"


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