Weird VarChar field udpate behavior

jda jda at his.com
Sun Dec 4 14:31:42 CST 2005


Hi Ruslan,

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).

Jon


More information about the Valentina mailing list