SQL no case

[Scott Runkel]

Thanks! Found it in the V4MD manual:

DB.setCollationAttribute( #kStrength, #kPrimary )


-SR

Scott Runkel
Director of Technology
Hypix Media, Inc.
503-722-2123
----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Tuesday, February 27, 2007 2:47 PM
Subject: Re: SQL no case


> On 28/2/07 12:31 AM, "Scott Runkel" <srunkel at hypix.com> wrote:
>
> Hi Scott,
>
>> In v1 there was an SQL key word "NO_CASE" or something like that. I can't 
>> find
>> the equivalent for v2, to ignore case in SELECT searches.
>
> There is no such equivalent
>
> Instead you should use
>
>    db.CollationAttribute( kStrength ) = kPrimary  (kSecondary)
>
> Then the whole db will be in case-insensitive state.
>
> You can specify this parameter for Table or field also.
>
>
> -- 
> 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
>