SqlSelect doesn't find text in textfield

[Markus Fraefel]

Thanks to all for the immediate response!
I switched the strength to secondary and now it works as I expect.
Regards,
Markus 

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
Sent: Dienstag, 23. September 2008 16:29
To: valentina at lists.macserve.net
Subject: Re: SqlSelect doesn't find text in textfield

On 9/23/08 5:25 PM, "Bart Pietercil" <bart.pietercil at cognosis.be> wrote:

>> res = gDB.SqlSelect( "SELECT Kapitel, Lauftext, zielFrame FROM 
>> Seiten_de WHERE lower(Kapitel) LIKE '%" &
>> Valentina.EscapeString(lower(searchTerm),1) & "%' OR Lauftext LIKE 
>> '%" &  Valentina.EscapeString(lower(searchTerm),1) & "%'", 
>> #kServerSide, #kReadWrite, #kRandom )
>> 
> 
> But I think you really need to read up on
> 
>
http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
ta
> tion:vkernel:database:locale&s=collation
> 
> remember that collation can be set on each level (db, tb, field) and
> that they can override (field has precedence and so on)
> I think you are after kStrength = kSecondary

And this is another good right way, if it is okay to have the whole
db/table/field to be with case-insensitive searches

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina