Information générale
Catégorie:
Codage, syntaxe et commandes
>I have several editboxes on assorted pageframes on a form. Some of the UPPER (change text to all caps within the editboxes) commands work and some don't.
>
>Here is one editbox example:
>
>In the LostFocus Event of the editbox I have -
>REPLACE mytable.myfield WITH UPPER(mytable.myfield)
>
>For properties I have -
>ControlSource = mytable.myfield
>Format = !K
>Read Only = .T.
>Enabled = .T.
>
>But I change Read Only to .F. when in Add record or Edit record mode so the editbox can be typed into.
>
>Any ideas why UPPER works for some of my editboxes and not others. It looks like I have the same general propety settings for all editboxes.
>
>Thanks for your ideas.
Hello Steve!
I guess, this problem nothing to do with UPPER but REPLACE.
No replacement occurs, if it is eof in the current workplace, even you preface the field with its alias. So try one of the followings:
a.
select myalias
replace field with upper(field)
b.
replace myalias.field with upper(myalias.field) in myalias
BB
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement