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