Loose search

[Ralf Sander]

Hi Ruslan,

I can't find examples or documentation with  StartWith, EndsWith, 
Contains and sql. Where is it hidden?

Or was this a hint to the Left / Right / Locate Example?
But while Left and Right are case intensitive, Locate is case 
sensitive, so no solution.


Many cheers,
Ralf


> On 2/28/05 6:43 PM, "Ralf Sander" <ralf at end-if.de> wrote:
>
>>> Hi Ralf,
>>>
>>> If you take a look on V4RB 2.0 beta,
>>> you will find exactly such example
>> Hi Ruslan,
>> not bad! But I am on the SQL way. Any solution for that?
>
> Yes Ralf,
>
> In the Exmaple/SQL_way you will find analogs for SQL.
>
> And 2.0 will do searches
>
>     StartWith, EndsWith, Contains
>
> Using index if it exists or without otherwise.





> On 2/28/05 11:59 AM, "Ralf Sander" <ralf at end-if.de> wrote:
>
>> Hi list,
>>
>> I am trying to create a very loose search like the one in the Finder:
>>
>> 1. "do" will find "document 23" or "my Doc" or "todo"
>> 2. but "image 34" fill find "iMage 34" and not "34 image"
>>
>> How can this be done in valentiva?
>
> Hi Ralf,
>
> If you take a look on V4RB 2.0 beta,
> you will find exactly such example
>
>
>> using index by words as fieldoption and "=" as operator does only find
>> whole words
>> using "LIKE" is not indexed and hence to slow for me.
>
>> using "LOCATE" would be the right function, but it seems not to be
>> implemented in 1.0 and it is case sensitiv.
>
> 2.0 have Vfield.Contains() fujction
>
> -- 
> 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
> -------------------------------------------------------------
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>