VText case insensitive search

[Bart Pietercil]

Hi Trausti,

I think you should be able to resolve that problem using the UPPER  
function


HTH

Bart Pietercil

On 13-feb-07, at 21:16, Trausti Thor Johannsson wrote:

> Hey list,
>
> I now have Valentina 2.5.5, running on Mac OSX 10.4.8 on Intel Mac,  
> Realbasic 2007R1.
>
> when I use the following sql search :
>
>     cursor = mDataBase.SqlSelect("select * from simptable where  
> ((texti like '%"+searchstring+"%') or (filename like  
> '%"+searchstring+"%'))",EVCursorLocation.kServerSide,  
> EVLockType.kReadWrite, EVCursorDirection.kRandom  )
>
>
> texti is a VText
>
>
> I can not search case in sensitive, for example if the "texti" has  
> a text which is "php", I can not search it by typing in PHP, I need  
> to type php in lowercase.
>
> Is this a limit ? Or would I be better served with doing object  
> search instead of sql search ?
>
>
>
> Best regards,
>
>
> Trausti
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina