SqlSelect doesn't find text in textfield

[Markus Fraefel]

Hi Thorsten

I don't understand. How would this look like in the following query?


res = gDB.SqlSelect( "SELECT Kapitel, Lauftext, zielFrame FROM Seiten_de
WHERE Kapitel LIKE '%" & Valentina.EscapeString(searchTerm,1) & "%' OR
Lauftext LIKE '%" &  Valentina.EscapeString(searchTerm,1) & "%'",
#kServerSide, #kReadWrite, #kRandom )

Regards,
Markus 

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Thorsten Hohage
Sent: Dienstag, 23. September 2008 15:46
To: Valentina Developers
Subject: Re: SqlSelect doesn't find text in textfield

Hi Markus,


On 2008-09-23, at 15:34, Markus Fraefel wrote:

> Another question: Searches in Valentina database seem to be case- 
> sensitive.
> Is there a way to switch this case-sensitivity off?


what's about using the lower() function on both site of the equitation?


regards,

Thorsten Hohage
-- 

Valentina Technology Evangelist
generic objects  GmbH - Leiter Solution Center Nord

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