Weird VarChar field udpate behavior

[Ruslan Zasukhin]

On 12/4/05 9:31 PM, "jda" <jda at his.com> wrote:

Hi Jon,

What is collation settings for you db?
    kPrimary? Else?


> I have a routine that changes the case of the text in a field (e.g.
> ruslan to RUSLAN). This works fine for an indexed VText field (where
> s = "RUSLAN"):
> 
>          myCursor.Field(fldName).setString(s)
>          myCursor.updateRecord  //ruslan -> RUSLAN
> 
> However, it does NOT work for an indexed VarChar field -- the text is
> *not* updated:
> 
>          myCursor.Field(fldName).setString(s)
>          myCursor.updateRecord  // ruslan -> ruslan
> 
> I can *force* it to udpate by doing this:
> 
>          myCursor.Field(fldNames).setString("")
>          myCursor.updateRecord
>          myCursor.Field(fldNames).setString(s)
>          myCursor.updateRecord
> 
> Looks like there may be an optimization in Valentina's code that
> mistakenly ignores case when updating VarChar fields (but not VText
> fields).

-- 
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]