| TIP: Click on subject to list as thread! | ANSI |
| echo: | |
|---|---|
| to: | |
| from: | |
| date: | |
| subject: | Paradox 4.5 labels |
DS->If a user creates a form/table that forces the initial letter of a name
to b
DS->cap and the rest of the letters in small letter, what is the best way to
for
DS->ALL caps when mailing labels are created?===
DS-> * QMPro 1.53 * Don't rush me. I get paid by the hour.
DS->--- TosScan 1.00
(1:226/12
PROC closed SHOUT(SomeString)
SomeString=upper(SomeString)
return SomeString
ENDPROC
SomeString = Shout(SomeString) ;you might use this in a
script, not a report
In a Report, you can call a report that has calclated fields, but you
really don't need the SHOUT proc, just UPPER("ralph") will give you RALPH
For more complex procedures you could do this
Shout(FNAME) Shout(LNAME)
Shout(Address1)
Shout([City]+", "+[ST]+" "+[Zip])
but for something as simple as upper case, this works more efficiently
Upper(FNAME) Upper(LNAME)
Upper(Address1)
Upper([City]+", "+[ST]+" "+[Zip])
using either assigned variable (lines 1 and 2) or just the table's field
names (line 3).
---
* SLMR 2.1 * Just cuz Im paranoid doesnt mean theyre not ALL after me!
--- QScan v1.141b / 01-0024
---------------
DS-> * Origin: Colossus - The Columbus Computer Society - Columbus, OH * Origin: (1:3407/14) |
|
| SOURCE: echomail via exec-pc | |
Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.