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