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

[Ruslan Zasukhin]

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]