V4RB 2.3 doesn't respect case-insensitivity when inserting new data

[Dave Addey]

Hi Ruslan,

Great stuff.  Thanks as ever for the help!

Dave.

> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Thu, 29 Jun 2006 08:42:57 +0300
> To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
> Conversation: V4RB 2.3 doesn't respect case-insensitivity when inserting new
> data
> Subject: Re: V4RB 2.3 doesn't respect case-insensitivity when inserting new
> data
> 
> On 6/29/06 1:25 AM, "Dave Addey" <listmail1 at dsl.pipex.com> wrote:
> 
>>> Q: you have set Strength = Primary for this one table only ?
>>>     or all your tables have the same settings?
>>> 
>>> If all the same then all you need is:
>>> 
>>>     db = new Vdatabase
>>>     db.Create  
>>>     db.SetCollationAttribute( kStrength ) = kPrimary
>> 
>> Actually, the code should be:
>> 
>>      db = new Vdatabase
>>      db.Create  
>>      db.CollationAttribute( EVColAttribute.kStrength ) =
>> EVColAttributeValue.kPrimary
>> 
>> ...but it's the same principle :-)
>> 
>>> It sounds to me like JUST only created objects of Vtable do not pickup your
>>> settings into work. After close, on next open they correctly setup self
>>> reading info from sys tables.
>> 
>> Yes, this is correct.  However, I just tried the approach mentioned above,
>> and this solves the problem!  If I set the strength to Primary for the
>> database rather than for each table, then newly-created objects do pick up
>> the setting correctly.
>> 
>>> As I see to reproduce your bug it needs NOT your database, but YOUR or
>>> similar small project that
>>>     create db and tables and set settings
>>>     add records
>>>     do LIKE search  -> see problem
>>> 
>>> Agree ?
>> 
>> I agree!  Unfortunately this would take quite a while for me to do - and you
>> just suggested a better workaround... I'll try and do this if I get time,
>> but for now, the approach described above solves the problem for me.  Of
>> course, if I needed a *different* strength for one of the tables in the
>> database, then I would hit the bug again...
> 
> I have add this letter to Mantis.
> 
> -- 
> 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