Error when tryijng to use Upper()
- Posted by ronaustin at alltel.net Oct 15, 2003
- 475 views
--------------Boundary-00=_FPVS6RO0000000000000 charset="iso-8859-1" I included wildcard.e and misc.e in my program and wrote to following to force text to upper case when it was saved.=0D =0D err =3D db_insert(Upper(getText(Code)),Upper(getText(Desc)))=0D =0D I get an error stating that "Upper is not defined". What am I doing wron= g?=0D =0D I would really prefer that the text be entered in upper case as the user types it, but I don't see any way to do that unless I get the letters one= at a time, convert them to upper case and then display them back on the scre= en.=0D =0D It would be nice if a flag could indicate that text should be entered in = upper case when using the SleText control. --------------Boundary-00=_FPVS6RO0000000000000 Content-Type: Text/HTML; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-= 1"> <META content=3D"IncrediMail 1.0" name=3DGENERATOR> <!--IncrdiXMLRemarkStart> <IncrdiX-Info> <X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID> <X-FVER></X-FVER> <X-CNT>;</X-CNT> </IncrdiX-Info> <IncrdiXMLRemarkEnd--> </HEAD> <BODY style=3D"BACKGROUND-POSITION: 0px 0px; SCROLLBAR-FACE-COLOR: #ebeae= a; FONT-SIZE: 12pt; MARGIN: 5px 10px 10px; SCROLLBAR-HIGHLIGHT-COLOR: #ae= aaaa; SCROLLBAR-SHADOW-COLOR: #a9a7a7; SCROLLBAR-3DLIGHT-COLOR: #e5e5e5; = SCROLLBAR-ARROW-COLOR: #875b38; FONT-FAMILY: Arial; SCROLLBAR-DARKSHADOW-= COLOR: #545252" bgColor=3D#ffffff background=3D"" scroll=3Dyes ORGYPOS=3D= "0" X-FVER=3D"3.0"> <TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D2 width=3D"100= %" border=3D0> <TBODY> <TR> <TD id=3DINCREDITEXTREGION style=3D"FONT-SIZE: 12pt; CURSOR: auto; FONT-F= AMILY: Arial" width=3D"100%"> <DIV>I included wildcard.e and misc.e in my program and wrote to followin= g to force text to upper case when it was saved.</DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>err =3D db_insert(Upper(getText(Code)),Upper(getText(= Desc)))</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>I get an error stating that "Upper is not defined".&n= bsp; What am I doing wrong?</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>I would really prefer that the text be entered in upp= er case as the user types it, but I don't see any way to do that unless I= get the letters one at a time, convert them to upper case and then displ= ay them back on the screen.</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>It would be nice if a flag could indicate that text s= hould be entered in upper case when using the <FONT size=3D2>Sl= eText </FONT> control.</DIV></FONT></TD></TR> <TR> <TD id=3DINCREDIFOOTER width=3D"100%"> <TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%"> <TBODY> <TR> <TD width=3D"100%"></TD> <TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle></TD> <TD id=3DINCREDIANIM vAlign=3Dbottom align=3Dmiddle></TD></TR></TBODY></T= --------------Boundary-00=_FPVS6RO0000000000000--